Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timeclock Calculation
I would like to set up a table in excel that allows me to enter, for example:
A time punched in (8:00 AM), time punched out (12:00 Noon) (for lunch) a time punched back in (1:00 PM), a time punched out (5:00 PM). I would like a final cell to calculate total work hours as 8 hours worked for the day. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timeclock Calculation
Hi
A1:E1 - "WorkdayStart", "LunchStart", "LunchEnd", "WorkdayEnd" Format columns A:D as time (like Custom "hh:mm") Into cell E2 enter the formula =IF(OR(A2="";D2=""),"",(D2-A2)-(C2-B2)) or, in case workday stretches over midnight =IF(OR(A2="",D2=""),"",(D2-A2+(D2<A2))-(C2-B2+(C2<B2))) and copy it down -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "john327" wrote in message ... I would like to set up a table in excel that allows me to enter, for example: A time punched in (8:00 AM), time punched out (12:00 Noon) (for lunch) a time punched back in (1:00 PM), a time punched out (5:00 PM). I would like a final cell to calculate total work hours as 8 hours worked for the day. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timeclock Calculation
enter in E2
=24*((D2-C2)+(B2-A2)) A2 = 08:00 B2= 12:00 C2= 01:00 p.m D2= 05:00 p.m. -- Greetings from New Zealand Bill K "john327" wrote in message ... I would like to set up a table in excel that allows me to enter, for example: A time punched in (8:00 AM), time punched out (12:00 Noon) (for lunch) a time punched back in (1:00 PM), a time punched out (5:00 PM). I would like a final cell to calculate total work hours as 8 hours worked for the day. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timeclock Calculation
See www.cpearson.com/excel/overtime.htm for examples and a
downloadable workbook. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "john327" wrote in message ... I would like to set up a table in excel that allows me to enter, for example: A time punched in (8:00 AM), time punched out (12:00 Noon) (for lunch) a time punched back in (1:00 PM), a time punched out (5:00 PM). I would like a final cell to calculate total work hours as 8 hours worked for the day. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |