Thread: Convert time stored as decimalised number to time format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
  
Posts: 284
Default Convert time stored as decimalised number to time format
Emma

A1/24 and formate as time

Mike Rogers

"Emma" wrote:

Hello
How can I convert 3.5 hours to 3:30:00?
--
Emma
Reply With QuoteReply With Quote