# Posts by zia.ziahussain

• ## Working Hours and Days calculations

Re: Working Hours and Days calculations

Thanks a ton NBVC for taking out your time to help me.However, the formulae given below does not solve the issue.Let me explain more what I am trying to dy by an example:

Working days are from Monday to Friday and the Day start @09:00 am to 23:00 (11pm)

For example the first case was recd on 9/16/2013 11:04

So the number of hours it remained open on 16 sept is 23:00-11:04=11:56 hours

And it was resolved on 17 September.So the number of hours it remained open on 17 sept is 09:00-13:01=04:01

So the total resolution time is 11:56+04:01=15:57 hours

Can you give it a shot again..

Thanks,
Zia

• ## Working Hours and Days calculations

I am trying to generate the SLA breach report for a helpdesk.The SLA is 42 hours(working). I am trying to calculate the Network Days and Network Hours between two dates with times. I want to know how many business days and hours are between the two days.

Variables:
- 'Case Open_Date' (A1)
- 'Case Close_Date.' (B1)
-'Difference Time' (E1)
-

Constants:
Work Days = Monday to Friday
Work Hrs = 09:00 AM to 11:00 PM (no lunch break)

Formats: