24 hours Shift payroll

  • Thread starter Thread starter negrito
  • Start date Start date
N

negrito

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate time if greater than a given time 5
Payroll calculations 1
VLookup in VBA? 5
Question on VBA Insertion of Additional Sheet 3
24 Hour Clock Calculations 1
Data Validation when entering hours over 24 8
Access Inventory Calculation 0
MS ACCESS INVENTORY CALCULATION 0

Back
Top