payroll formula when shift is 3pm to 1 am
 

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?

payroll formula when shift is 3pm to 1 am
 

in custom format type
[h]:mm


"payroll spreadsheet help" skrev:

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?

payroll formula when shift is 3pm to 1 am
 

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
wrote in message
...
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?

payroll formula when shift is 3pm to 1 am
 

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

C1 =B1-A1+1


"payroll spreadsheet help" wrote:

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?

payroll formula when shift is 3pm to 1 am
 

That could cause all kinds of problems!

Biff

"Teethless mama" wrote in message
...
A1 = 4:00 PM
B1 = 2:00 AM

C1 =B1-A1+1


"payroll spreadsheet help" wrote:

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?