| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I calculate daily hours worked minus lunch to eual a decim
example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM
=13.25 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I calculate daily hours worked minus lunch to eual a decim
Assuming
A2: start time B2: Lunch out C2: Lunch in D2: End time =((D2-A2)-(C2-B2))*24 "lili" wrote: example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM =13.25 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I calculate daily hours worked minus lunch to eual a d
This only works for AM times. If I want it to work for PM starts I have to ad
24. How do I work it all into one formula that will work for both? "Teethless mama" wrote: Assuming A2: start time B2: Lunch out C2: Lunch in D2: End time =((D2-A2)-(C2-B2))*24 "lili" wrote: example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM =13.25 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I calculate daily hours worked minus lunch to eual a d
Assuming
A2: start time B2: Lunch out C2: Lunch in D2: End time =((D2-A2+(A2D2))-(C2-B2+(B2C2)))*24 "lili" wrote: This only works for AM times. If I want it to work for PM starts I have to ad 24. How do I work it all into one formula that will work for both? "Teethless mama" wrote: Assuming A2: start time B2: Lunch out C2: Lunch in D2: End time =((D2-A2)-(C2-B2))*24 "lili" wrote: example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM =13.25 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I calculate daily hours worked minus lunch to eual a d
You are one Freak'n GENIUS, Theethless
mama!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! "Teethless mama" wrote: Assuming A2: start time B2: Lunch out C2: Lunch in D2: End time =((D2-A2+(A2D2))-(C2-B2+(B2C2)))*24 "lili" wrote: This only works for AM times. If I want it to work for PM starts I have to ad 24. How do I work it all into one formula that will work for both? "Teethless mama" wrote: Assuming A2: start time B2: Lunch out C2: Lunch in D2: End time =((D2-A2)-(C2-B2))*24 "lili" wrote: example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM =13.25 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I calculate daily hours worked minus lunch to eual a decim
Assuming your times are in A1 to D1, then try this:
=(D1-C1+B1-A1)*24 Format the cell as number with 2 dp. Hope this helps. Pete On Mar 28, 12:00 am, lili wrote: example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM =13.25 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I calculate daily hours worked minus lunch to eual a d
"Pete_UK" wrote: Assuming your times are in A1 to D1, then try this: =(D1-C1+B1-A1)*24 Format the cell as number with 2 dp. Hope this helps. Pete On Mar 28, 12:00 am, lili wrote: example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM =13.25 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| Calculate hours worked | New Users to Excel | |||
| Need formula to calculate hours worked | Excel Discussion (Misc queries) | |||
| CALCULATE HOURS WORKED | Excel Discussion (Misc queries) | |||
| calculate average hours worked | Excel Worksheet Functions | |||
Hybrid Mode
