hours and minutes
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
Pam Coleman wrote:
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.
--
Dave Peterson
|