Total Work Hours

[andersonbda]

I need a way to calculate the total hours between two dates and times with the following assumptions:
If start time is before 8AM work is assumed to start at 8AM
If end time is after 4pm, work is assumed to end at 4pm
Start and end times that span multiple days assumes an 8am to 4pm work day

Holidays are excluded

5/24/13	5:16 PM	5/29/13	9:15 AM
5/3/13	2:16 PM	5/6/13	4:25 PM
5/15/13	10:03 PM	5/16/13	3:41 PM

<TBODY>
</TBODY>

5/27/13 is a holiday and should be excluded.
This is the result I want
Total Hours

1.25

9.73

13.63

<TBODY>
</TBODY>

Thanks!

 

[andersonbda]

Oh Yeah... and the formula should exclude weekends (Sat, Sun) and holidays (listed in a separate row- lets say row F).

 

[andersonbda]

I see there have been no takers... I suppose I would take the answer in an [h]:mm format too.