Time sheet.

C

cartel1

I am trying to create a time sheet where the hours are listed as in/out(am),
then in/out(pm). going from B to E with the total hours being calculated in
row H. Listing Monday through Sunday on rows 8 through 14.
I have a working formula for adding up the total hours from the week at
the bottom(ie.40 hours), but I cannot figure out the formula to add the daily
time. If I put in "in at 9, out at 12:00 for lunch, back at 12:30 and out at
5:30, it won't come up with 9 hours. If i simply put in "in at 9 and out at
5, it gives me 14. What do I need to do?
Thanks for any help.
 
S

Sean Timmons

Well, the formula would be =(C2-B2)+(E2-D2)

Format as hh:mm

also, make sure all of your times are formatted as HH:MM as well...
 
S

Sandy Mann

=(C2-B2)*24+(E2-D2)*24

You only need to multiply by 24 once, and assuming that the first in is B2,
first out C2, etc.

=(C2-B2+E2-D2)*24

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

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