Thread: time conversion
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
  
Posts: 1,805
Default time conversion
Divide by 24 and format as h:mm:ss

"GAIDEN" wrote:

how do i convert 6.12 hours to its time equivalent 06:07:12? i tried custom
formatting using h:mm:ss but i get 2:52:48.
Reply With QuoteReply With Quote