Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
minutes seconds days weeks years
I have a spreadsheet that in column A= seconds. I want to take the
seconds in col a and convert to minutes in col B, then in col C convert to hours and in col D convert to days - this is the formula that was given to me yesterday. =a1/60 (in B1) would contain minutes =b1/60 (in C1) would contain hours =c1/24 (in D1) would contain days Question now in col E I need to convert the days into weeks and in col F the weeks into years. What would the formula be for this and also, what would the formatting be, I do not want to round. I went into Custom and chose hh:mm:ss, is this correct? Thanks, If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I calculate times in seconds and minutes using percentages | Excel Worksheet Functions | |||
How do I sum increments of minutes and seconds | Excel Worksheet Functions | |||
How to calculate in weeks and days? | Excel Discussion (Misc queries) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
convert seconds to minutes and seconds | Excel Worksheet Functions |