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..