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
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
Yes
[h] "hours and" mm "minutes"
--
Regards,
Peo Sjoblom
(No private emails please)
"dhollifield" <[email protected]> wrote in message
news:[email protected]...
>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
Try the custom format
[hh] "hours and" mm "minutes"
Hope this helps
Rowan
dhollifield wrote:
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks