Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hours and minutes
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
hours and minutes
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 -- Brevity is the soul of wit. "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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
hours and minutes
how do I take the hours and make days then weeks then years.
Thanks, "Bernard Liengme" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
Calculating and Adding Hours, Minutes, and Seconds in a CALL LOG | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions |