Time sheet.
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 |
Time sheet.
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 |
Time sheet.
=(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 |
Time sheet.
=(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 |
All times are GMT +1. The time now is 09:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com