Hi,

Awhile back I was here asking questions about a formula calculate elapsed time between 2 dates, but that did not count hours overnight. There was a helpful response from daddylonglegs as follows :

If you have start time and date in A2, end time and date in B2 and your daily start time (08:00) in F2 and daily end time (21:00) in F3 you can use this formula :
=(INT(B2)-INT(A2))*($F$3-$F$2)+MEDIAN(MOD(B2,1),$F$2,$F$3)-MEDIAN(MOD(A2,1),$F$2,$F$3)

Because I do not know enough about Excel I do not know how (or if it's possible) to change this formula for other scenarios.

For example, a service calendar (clock) that was active Mon-Fri 7am-7pm
or Mon-Fri 24 Hours.

Any clues? Or do I need different formulas altogether?

The reporting I do could incorporate all these circumstances in one report, and frankly, it's doing my head in.

Thanks
Narelle.