Hi,

Try this

=IF(A1B1,B1+1-A1,B1-A1)
Format as hh:mm

Mike

"Nikki27" wrote:

I have set up a timesheet that allows you to clock in and clock out each day.
This set up was the preferred method for employees.
However, I now have the problem of being able to add hours worked when
starting shift in the PM of one day and finishing shift in the AM of the next
day.
Is there a formula to manipulate this information?