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.
SherylYoung's avatar
SherylYoung
Qrew Member
9 years ago

No weekends, please. I have the basic formula however I need the dates results without hours after 8pm.


Example: [ Actual End Time And Date]-[Actual Start Time And Date]