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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top