| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
24 hours Shift payroll
Can someone help me, I need help.
Exel formula to calculate 24 hours payroll Start time 8:00 AM Ending Time 10:50 AM Next Day |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
24 hours Shift payroll
Unless you know the start and end times will always exceed 24 hours, you
would need to include the date as well A1: 9/25/2006 08:00 AM A2: 9/26/2006 10:50 AM A3: =(A2-A1)*24*B1 B1: $25.50 'hourly rate Format A3 as currency or number (it will probably default to date). if the end time will always be after the start time and exceed 24 hours A1: 08:00 AM A2: 10:50 AM A3: =(A2-A1+1)*24*B1 B1: $25.50 'hourly rate -- Regards, Tom Ogilvy "negrito" wrote: Can someone help me, I need help. Exel formula to calculate 24 hours payroll Start time 8:00 AM Ending Time 10:50 AM Next Day |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting hours for payroll purposes | Excel Discussion (Misc queries) | |||
| payroll formula when shift is 3pm to 1 am | Excel Discussion (Misc queries) | |||
| payroll hours | Excel Discussion (Misc queries) | |||
| How do I calculate total weekly hours for payroll in Excel? | Excel Discussion (Misc queries) | |||
| Payroll hours | Excel Discussion (Misc queries) | |||
Linear Mode
