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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
The field type should be formula numeric. If that does not work please post the complete formula.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
I did a test and the formula works if you fix my error here

var timeofday DayStartTime = ToTimeOfDay("4:00 am");
var timeofday DayEndTime = ToTimeOfDay("11:59 pm");


I had those backwards.

Let know how it tests.