employee time sheet hours

**dude2125** · 10-28-2007, 03:23 AM

I am making a time sheet that calculate employee hours scheduled using a simple formula (b2-a2). My problem is when the scheduled out time goes to the next day (6:00pm to 1:00am) excel returns "#value". Please help.

dude2125

**VBA Noob** · 10-28-2007, 04:17 AM

Try

=B1-A1+(A1>B1)

VBA Noob

**dude2125** · 10-28-2007, 09:04 AM

That helped Thank You! I would also like to know if there is a way to convert the result into decimal form in the same formula.

dude2125

**dude2125** · 10-28-2007, 10:16 AM

I have ran into another issue. If an employee is scheduled from 9 am to 5 pm the above formula calculate the time wrong 16 hours instead of 8.

dude2125