Hi Everybody,
I need help to calculate time outside contract hours. I have attached file with almost everything ready only i was not able to do is count of time outside contract hours. Out contract hours are from Morning 06:00AM to 20:00PM.
for example in the attached file if you look at row 6 date 21st April 2012 time start is 04:45am & time finish is same day 0930:am so manually counting outside contract hours should be only 01:15 hours only but i am getting answer 22:45.
Date Time Start Time Finish Duration hh:mm Outside Contract Hrs
21-Apr-12 4:45 9:30 4:45:00 22:45
Any help on the above is highly appreicated.
Cheers,
Mehul
Bookmarks