converting a number to time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Divide the result by 1440 and format it as a time. (The reason for 1440 is
that there are 1440 minutes in a day, and '1' represents a day to Excel).
--Bruce
 
Back
Top