Calculate time

  • Thread starter Thread starter Tina
  • Start date Start date
T

Tina

I tried to use a timesheet template suggested in past post
but I need to have a time sheet for more than one
departure. For instance, I come to work, leave for class,
return to work, leave out for class, return to work, then
end the work day. I am having a problem working the last
out and in into the formula. Any suggetions?

Thanks,

Tina
 
Tina,

Put all of the times in separate cells and then just work through them, for
instance

=(B1-A1)+((D1-C1)+(F1-E1)

etc.
 
Back
Top