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.
--
cartel1

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...

"cartel1" wrote:

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.
--
cartel1

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

"cartel1" wrote:

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.
--
cartel1

=(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


Replace @mailinator.com with @tiscali.co.uk


"Mike" wrote in message
...
=(C2-B2)*24+(E2-D2)*24

"cartel1" wrote:

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.
--
cartel1