Thread: convert time to text
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default convert time to text
One way:

A1: 47.75
A2: =TEXT(A1/24,"[h] ""hrs and ""mm"" minutes""")

In article ,
checkQ wrote:

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