View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

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