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