Hello, I use this formula to calculate working hours. Any idea why the working hours would populate 10:13, and not 4:41. Our hours are 0800 to 1700. It seems to work fine if the start time is after 08:00? Thanks for any help.
1/9/17 2:28 1/9/2017 12:41 10:13
Please Login or Register to view this content.
Last edited by steve400243; 03-20-2017 at 12:44 PM.
Here is the sample file - Sorry forgot to attach
Well, your first IF statement only checks if Receive date & Stop date falls on same date and subtracts Receive date from Stop date.
Try formula belowPlease Login or Register to view this content.
Please Login or Register to view this content.
That did it, Thanks very much CK76Originally Posted by CK76
Well, your first IF statement only checks if Receive date & Stop date falls on same date and subtracts Receive date from Stop date.
Try formula belowPlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks