Time Sheet calculations

[Biff]

Hi John,

Try this formula in the column for TOTAL HOURS if the time
during the break periods *will not span past midnight*

=ROUND(((F2-A2+(A2>F2))-SUM(C2-B2,E2-D2))*24/0.25,0)*0.25

If the time during the break periods *will span past
midnight*, use this formula:

=ROUND(((F2-A2+(A2>F2))-SUM(C2-B2,E2-D2)-(B2>C2)-(D2>E2))
*24/0.25,0)*0.25

Copy down as needed and Format as GENERAL. Then to get the
TOTAL HOURS FOR WEEK, you would simply use the sum
function:

=SUM(G2:G8)

Biff