Forum Discussion

SherylYoung's avatar
SherylYoung
Qrew Member
9 years ago

I want to calculate duration from 2 dates and 2 times. The span of time for each day is 8am-8pm; hours after 8pm should not be counted.

I need help. I am trying to calculate duration from 2 dates and 2 times.However the span of time for each day is 8am-8pm. The hours after 8pm should not be in the calculation.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
I don't have an instant answer for you, but do weekends count?  I have done these formuals before and they tend to be very long and messy.