payroll formula when shift is 3pm to 1 am

  • Thread starter payroll spreadsheet help
  • Start date
P

payroll spreadsheet help

I am fine tuning our payroll spreadsheet, and we have several employees who
work from 4pm to 1 or 2 am. The current formula's treat each day as 24 hours,
ending at 12pm. Is there a formula that I can use to show the hours worked
when the ending time is after12 pm?
 
B

Biff

Try this:

A1 = 4:00 PM
B1 = 2:00 AM

=B1-A1+(B1<A1)

Formatted as [h]:mm retruns 10:00

If you want the result as a decimal value:

=(B1-A1+(B1<A1))*24

Formatted as GENERAL returns 10

Biff

"payroll spreadsheet help" <payroll spreadsheet
[email protected]> wrote in message
news:[email protected]...
 
Top