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?