Time formulation?

[LGrobe]

I am trying to figure time worked on a daily basis. I have done thi
formula before, but have forgotten how to complete it.

My times look like (2nd shift hours)
3:30 PM
12:30 AM
The formula needs to calculate hours worked greater than 5.5 to tak
out 1/2 hour lunch, and hours worked less than 5.5 to calculate tota
hours with no lunch. We do not clock in and out for lunch breaks, i
is an automatic deduction, but somebody has earased my formula.

Please help!

 

[JE McGimpsey]

One way:

A1: <start time>
B1: <end time>
C1: =MOD(B1-A1,1) - (MOD(B1-A1,1)>TIME(5,30,1))/48

Note, the 1 second in TIME(5,30,1) should prevent any rounding errors
from inadvertently taking off a lunch period at exactly 5.5 hours,
assuming you only enter time in hours and minutes.