If you want to use Excel time format divide 90 by 1440 then format the cell
as hh:mm
=A1/1440
with 90 in A1 formatted as hh:mm will give you 01:30
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"SheriTingle" wrote in message
...
Hello and thanks for the help. I am using Excel 2000. I have a list of
numbers ranging from 1 to 60. These numbers represent minutes. When I add
them up at the end I obviously still have a number representing minutes.
What
I would like is for that number to convert to hours and minutes. Example
if
the list adds up to 90, I would like the answer to say 1 hour 30 minutes.
Is
that possible?