hours and minutes
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
"Pam Coleman" escreveu na mensagem
...
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.
|