payroll formula when shift is 3pm to 1 am

[Guest]

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?

 

[Guest]

in custom format type
[h]:mm


"payroll spreadsheet help" skrev:

 

[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
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

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

C1 =B1-A1+1

 

[Biff]

That could cause all kinds of problems!

Biff

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

C1 =B1-A1+1