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.
 

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

Back
Top