Forum Discussion

SherryBlackburn's avatar
SherryBlackburn
Qrew Trainee
7 years ago

Date/Time duration formula in hours, excluding 12am-4am

I am calculating elevator/escalator outages and need a formula that will calculate the hours between two Date/Time fields "Incident Start Date/Time" and "Incident End Date/Time".  The kicker is I need...
Formulas and functions
EndyLu's avatar
EndyLu
Qrew Trainee
6 years ago
how will this formula works if I want to exclude weekends? I only want to include regular business hours 9-5 Monday to Friday!

------------------------------
Endy Lu
------------------------------
AustinK's avatar
AustinK
Qrew Commander
6 years ago
Go with one of the original formulas above. If you read through the thread there is a point where they got the formula to work perfectly for their needs except it was still excluding weekends. I'd imagine if you took that formula and changed the start and end times to be 9 am and 5 pm that it would work for you or be really close to working for you and only need some small adjustments.