Hourly Work Sheet

  • Thread starter Thread starter skillsaw
  • Start date Start date
S

skillsaw

Would appreciate some help setting up a weekly work schedule....can d
the layout and some minor formulas but can't seem to get a grip on ho
to calculate total hours and minutes from start times entered and sto
times entered.....ie.. in at say 8:30 am and out at 5pm....could go th
other way around also...in at 8:30 pm and out at 5am.....would also b
nice to have it read in hour:minute format.....thanks i
advance!:confused
 
Assuming that both day and night shift have one hour for
dinner then
=IF(B7>C7,(C7+0.5)-B7-0.041667,C7-B7)

if start time is in B7 and end time is in C7


0.041667 is 1/24 of a day

e-mail: (e-mail address removed)
Regards
Peter
 
Did you ever get the answer to the question? I'm having the same problem

----- skillsaw > wrote: ----

Would appreciate some help setting up a weekly work schedule....can d
the layout and some minor formulas but can't seem to get a grip on ho
to calculate total hours and minutes from start times entered and sto
times entered.....ie.. in at say 8:30 am and out at 5pm....could go th
other way around also...in at 8:30 pm and out at 5am.....would also b
nice to have it read in hour:minute format.....thanks i
advance!:confused
 
Back
Top