Excel stores time as a number, 1 day is 1, one hour = 1/24 so 6 hours is
the equivalent of 0.25, only the formatting makes it a time.

Does this help? If not please elaborate further, what formula are you
using, what result do you expect, what do you get?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=555974