Thread: time conversion
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GAIDEN GAIDEN is offline
external usenet poster
  
Posts: 30
Default time conversion
thanks, that worked

"Sheeloo" wrote:

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