display words in a formula result in Excel

Thread view:

Thread rating:

dhollifield - 18 Nov 2005 03:35 GMT

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 - 18 Nov 2005 03:39 GMT

Yes

[h] "hours and" mm "minutes"

Signature

Regards,

Peo Sjoblom

(No private emails please)

>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

Rowan Drummond - 18 Nov 2005 03:41 GMT

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

Hope this helps
Rowan

> 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