View Single Post
  #1   Report Post  
JLHORMAN
 
Posts: n/a
Default convert number to time format?


I have a column of 3-4 numbers representing time of day. The number vary
from 63 (=6:30 AM) to 113 (= 11:30 AM). Can anyone help me to convert
the numbers to time format? Thanks.


--
JLHORMAN
------------------------------------------------------------------------
JLHORMAN's Profile: http://www.excelforum.com/member.php...o&userid=23768
View this thread: http://www.excelforum.com/showthread...hreadid=374148