Thread: Convert real number to an h:mm:ss display
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Weyand
 
Posts: n/a
Default Convert real number to an h:mm:ss display
Let's say I have a real number, i.e. 123456.789, that is in seconds and I
want to display it as 34:17:37. I kinda got lost trying to use
TEXT(TIME(etc.)). Maybe there is a better way.

--


Reply With QuoteReply With Quote