Times are stored as fractions of a day. A 24hr period=1 So to convert
your answer divide the answer in minutes by 1440 (24hr x 60 minutes).
The Result needs to be formated [h]:mm to display the result in hours
and minutes. You can type this in the custom format box. Not that I
think it will effect you you can not have a negative number of hours or
minutes
Regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=509267