Thread: 3.02 PM ( Decimal Point )to 1502
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default 3.02 PM ( Decimal Point )to 1502

Do you want 15:02 as a time or 1502 text value?

either

=SUBSTITUTE(B71,".",":")+0

format as hh:mm

or for text

=TEXT(SUBSTITUTE(B71,".",":")+0,"hhmm")


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

Reply With QuoteReply With Quote