Really, that surprises me. I would have thought that once you go over 6
hours it would mean that a lunch-break was taken, otherwise not. Still, no
matter, you got it working which is the important thing.

Regards

Bob


"navychef" wrote in
message ...

AWESOME! Thank you SO MUCH!

That is REALLY perfect, I wasn't anywhere close to it! Formula works
great. I just added in an = to also subtract the .5 when it's equal to
6 hours.

THANK YOU!!!!!!!!!!!

Bob


--
navychef
------------------------------------------------------------------------
navychef's Profile:
http://www.excelforum.com/member.php...o&userid=29457
View this thread: http://www.excelforum.com/showthread...hreadid=491668