View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default hours and minutes

Since there are 60 seconds in a minute, =A1/60 will convert seconds in A1 to
minutes. IF you just want to see whole minutes without fractions (e.g 75 sec
= 1.25 mins, but you want to see just 1) then use =ROUND(a1/60,0). But this
will round 90 secs to 2 mins, so if you want the answer to be 1 use
=INT(A1/60)
Min to hours: divide the hours answer by 60
Hrs to days: divide the hours answer by 24
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Pam Coleman" wrote in message
...
If I have a spreadsheet that in column A= seconds. I want to take the
seconds in col a and in column b make minutes, then in column c, the
minutes
to make hours, and then in column d, the hours to make days. I do not
know
how to divide to get the correct answer in each of the columns.