View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dav
 
Posts: n/a
Default Convert a number to a time


Depending what you wish to do excel stores times as well as dates as
numbers, with 1 being a full day. An option is to divide everything by
24 and use a custom format of dd hh:mm although this will express the
hours as days and hours

It depends what you want to do really


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=502807