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
Right, the formula was designed to count business hours not counting weekends. But I am pretty sure I know how to change the formula to adjust for that. But I�m in a car now, so I will get to it when I can.
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    I have a formula that is easy to understand that I will post shortly. 

    Three questions:

    (1) Is there a increment of time you want the formula to use? Like 1 minute, 15 minutes or an hour?

    (2) Do you want to round up or round down?

    (3) What type of output do you want? Numeric or Duration?