Calculate time

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
 
B

Bob Phillips

Tina,

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

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

etc.
 
Top