View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default display words in a formula result in Excel

Yes

[h] "hours and" mm "minutes"

--
Regards,

Peo Sjoblom

(No private emails please)


"dhollifield" wrote in message
...
I used the [hh]:mm number format to add hours and minutes. Is there a way
to
display the result of 46:40 as 46 hours and 40 minutes