Thread: Convert decimal hours to time24hrs
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tony Tony is offline
external usenet poster
  
Posts: 1
Default Convert decimal hours to time24hrs
I would be more precise =CONCATENATE((ROUNDDOWN(A8,0),":",INT((A8-ROUNDDOWN(A8,0))*60+.5)) THUS INSTEAD OF 78:43 YOU WILL GET 78:44 AS EXPECTED
Reply With QuoteReply With Quote