Thread
:
How do I convert times from hours to minutes?
View Single Post
#
2
Nick Hodge
Posts: n/a
Kim
It is incrementing minutes greater than 60 to hours but not showing them. Go
to FormatCells...NumberCustom and enter [mm]:ss
the [ ] stop it incrementing. the same with hours to days [h] or [hh]
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"kkrebs" wrote in message
...
I am trying to do a spread sheet where I have a starting time of 10:00am
and
an ending time of 11:30am and I want the sum to be total minutes not hours
and minutes. It comes out at 30:00 and I can't figure out how to have it
add
in the other hour. Can any one help?
Thank you!
Kim
Reply With Quote