View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dav
 
Posts: n/a
Default ANYONE GOT THE TIME?


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