hours and minutes

[Guest]

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.

 

[Bernard Liengme]

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

 

[Dave Peterson]

If A1 contains Seconds, then
=a1/60 (in B1) would contain minutes
=b1/60 (in C1) would contain hours
=c1/24 (in D1) would contain days

 

[Guest]

In column B: =A1/60 will give you the minute equivalent.
In column C: =B1/60 will give you the hour equivalent
In column D: =C1/24 will give you the day equivalent

If A1 = 60 seconds, then B1 = 1, C1 = 1/60 of an hour, D1 = 1/(60)*(24) of a
day.

Dave

 

[Rodrigo Ferreira]

I think you can do this:
A5 = 616565 (your seconds)
B5 = =INT((((A5/60)/60)/24)) (days)
C5 = =INT(((A5/60)/60))-(INT((((A5/60)/60)/24))*24) (hours)
D5 = =INT(MOD(A5/60;60)) (minutes)
E5 = =INT(MOD(A5;60)) (seconds)

Rodrigo Ferreira

 

[Guest]

how do I take the hours and make days then weeks then years.

Thanks,