display words in a formula result in Excel

dhollifield · Nov 18, 2005

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

Peo Sjoblom · Nov 18, 2005

Yes

[h] "hours and" mm "minutes"

--
Regards,

Peo Sjoblom

(No private emails please)

Rowan Drummond · Nov 18, 2005

Try the custom format
[hh] "hours and" mm "minutes"

Hope this helps
Rowan