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

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