I'm trying to calculate elapsed time in hours from a start date/time to an end date/time.
Work hours are M-F, 6AM - 6PM.
Below is the formula I'm using.
=(NETWORKDAYS(B3,C3)-1)*("18:00"-"6:00")+MOD(C3,1)-MOD(B3,1)
The problem I'm having is if the start day is after business hours or on...