Hi Everyone; I'm hoping you can help me.
I'm trying to calculate the available man hours I have for my shift/team. I have got the basic formula to deduct the time, and lost time for breaks ok, but when the shift end time crosses midnight the formula returns a "value" error message. i.e. start time = 18:00. End time = 24:00 breaks = 15 mins gives me a formula like this =TEXT(O17-N17-P17,"h:mm") and a result of 5:45
Any ideas how I can make this formula work so it can calulate the variance even though the shift ends at 02:00am the following morning?
Any thoughts gratefully received.