Thread: Convert decimal hours to time24hrs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
  
Posts: 141
Default Convert decimal hours to time24hrs
Can someone please tell me how to convert a value formatted as a number and convert it to an hh:mm format (not in text)? eg. 78.73 hours to 78:44
Reply With QuoteReply With Quote