Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for calculating time
I am establishing a Timesheet for our business in Excel. I have cells for
"In" , "Lunch Out", "Lunch In" and "Out" that employees will enter their times (in military time). Need the formula that will calculate the total hours for the day, subtracting out for the lunch break. Thanks! |
#2
|
|||
|
|||
Hi!
B2 = time in C2 = lunch out D2 = lunch in E2 = time out Total =IF(C2="","",(E2-D2+(D2E2)+C2-B2+(B2C2))) Returns in the format of h:mm - 8:45 For a return in decimal format - 8.75 =IF(C2="","",(E2-D2+(D2E2)+C2-B2+(B2C2))*24) Biff "kc sunshine" <kc wrote in message ... I am establishing a Timesheet for our business in Excel. I have cells for "In" , "Lunch Out", "Lunch In" and "Out" that employees will enter their times (in military time). Need the formula that will calculate the total hours for the day, subtracting out for the lunch break. Thanks! |
#3
|
|||
|
|||
Kc, have a look here
http://www.cpearson.com/excel/overtime.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "kc sunshine" <kc wrote in message ... I am establishing a Timesheet for our business in Excel. I have cells for "In" , "Lunch Out", "Lunch In" and "Out" that employees will enter their times (in military time). Need the formula that will calculate the total hours for the day, subtracting out for the lunch break. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Polynimial trandline formula | Charts and Charting in Excel | |||
Formula for time | Excel Discussion (Misc queries) | |||
Formula for time? | Excel Discussion (Misc queries) | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel |