I am trying to figure time worked on a daily basis. I have done this
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 take
out 1/2 hour lunch, and hours worked less than 5.5 to calculate total
hours with no lunch. We do not clock in and out for lunch breaks, it
is an automatic deduction, but somebody has earased my formula.

Please help!!


--
LGrobe
------------------------------------------------------------------------
LGrobe's Profile: http://www.excelforum.com/member.php...o&userid=26350
View this thread: http://www.excelforum.com/showthread...hreadid=396166