| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add hours worked in exel
I work different times every week.I want to be able to total the hours worked
each day to include overtime for each week automatically. for example day one I work from 2PM to 8 Pm .over time starts at 6pm. normal payment is $25.00 overtime is 15%+ Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add hours worked in exel
To specifically address your question:
Cell A1 enter time in. Cell B1 time out. Cell C1 this: =IF(B1<=0.75,(B1-A1)*24*25,(0.75-A1)*24*25+(B1-0.75)*24*25*1.15) A better approach, though, is to get yourself a well designed timesheet. "Wilfred" wrote: I work different times every week.I want to be able to total the hours worked each day to include overtime for each week automatically. for example day one I work from 2PM to 8 Pm .over time starts at 6pm. normal payment is $25.00 overtime is 15%+ Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add hours worked in exel
Assuming you don't work through midnight, and overtime rate begins at 6:00 PM
regardless of hours workd. "Tevuna" wrote: To specifically address your question: Cell A1 enter time in. Cell B1 time out. Cell C1 this: =IF(B1<=0.75,(B1-A1)*24*25,(0.75-A1)*24*25+(B1-0.75)*24*25*1.15) A better approach, though, is to get yourself a well designed timesheet. "Wilfred" wrote: I work different times every week.I want to be able to total the hours worked each day to include overtime for each week automatically. for example day one I work from 2PM to 8 Pm .over time starts at 6pm. normal payment is $25.00 overtime is 15%+ Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| Most hours worked | New Users to Excel | |||
| How do I get Exel to return # of hrs. worked, start time is enter | Excel Worksheet Functions | |||
| Hours worked | Excel Worksheet Functions | |||
![Wilfred[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
