View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default converting a number to time

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?