Thread: convert time to text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
checkQ checkQ is offline
external usenet poster
  
Posts: 38
Default convert time to text
Hi,
Does anyone knows a formula to convert the decimal time 47.75 to text in
order to read 47 hrs and 45 minutes?
Thanx
Reply With QuoteReply With Quote