Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert minutes to seconds
Hi,
I'm still new to formula's however seem to be finding my way around the basics so please not too much jargon if you know the answer to my question - thank you. I have a time that is documented in minutes and seconds ie 2.40 however I believe I will need to convert these to seconds, to enable me to obtain an average - is this correct or can anyone help me. COL A COL B COL C COL D COL E Average 2.40 2.14 2.32 2.52 Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert minutes to seconds
If those entries were *legal* XL times, use:
=Average(B1:E1) However, by the looks of your data, I doubt it! Easiest way is to enter *true* XL times in cells formatted to Time: 00:02:40 You could custom format to use the decimal for the seconds: 00:02.40 In that way you can calculate with math functions. If your data is really plain, keyed in numbers, you'll have to perform more complicated procedures to get what you're looking for. SO ... which is it? What type of values do you have in your sheet? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jane D" <Jane wrote in message ... Hi, I'm still new to formula's however seem to be finding my way around the basics so please not too much jargon if you know the answer to my question - thank you. I have a time that is documented in minutes and seconds ie 2.40 however I believe I will need to convert these to seconds, to enable me to obtain an average - is this correct or can anyone help me. COL A COL B COL C COL D COL E Average 2.40 2.14 2.32 2.52 Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert minutes to seconds
Hi Jane
-- If 2 hours 30 minutes is recorded as 2.3 to convert in into seconds use the formula =INT(A1)*60+MOD(A1,1)*100 -- If 2 hours 30 minutes is recorded as 2.5 to find an average just use the AVERAGE() function. PS: It is always easy to handle time if the data is in excel time format.. If this post helps click Yes --------------- Jacob Skaria "Jane D" wrote: Hi, I'm still new to formula's however seem to be finding my way around the basics so please not too much jargon if you know the answer to my question - thank you. I have a time that is documented in minutes and seconds ie 2.40 however I believe I will need to convert these to seconds, to enable me to obtain an average - is this correct or can anyone help me. COL A COL B COL C COL D COL E Average 2.40 2.14 2.32 2.52 Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert minutes to seconds
Hi,
If you must keep the entries in this form, If 2.5 means 2 minutes and 30 seconds then =A1*60 will convert this to 150 seconds If 2.5 means 2 minutes and 50 seconds then =60*INT(A1)+100*MOD(A1,1) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Jane D" wrote: Hi, I'm still new to formula's however seem to be finding my way around the basics so please not too much jargon if you know the answer to my question - thank you. I have a time that is documented in minutes and seconds ie 2.40 however I believe I will need to convert these to seconds, to enable me to obtain an average - is this correct or can anyone help me. COL A COL B COL C COL D COL E Average 2.40 2.14 2.32 2.52 Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert minutes to seconds
How are you preserving that trailing 0 in your 2.40 entry? Is the entry
formatted as Text, or is it a number with a Custom Format? -- Rick (MVP - Excel) "Jane D" <Jane wrote in message ... Hi, I'm still new to formula's however seem to be finding my way around the basics so please not too much jargon if you know the answer to my question - thank you. I have a time that is documented in minutes and seconds ie 2.40 however I believe I will need to convert these to seconds, to enable me to obtain an average - is this correct or can anyone help me. COL A COL B COL C COL D COL E Average 2.40 2.14 2.32 2.52 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to convert 157.25 minutes, into hours, minutes and seconds. | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Minutes to seconds - how to convert? | Excel Worksheet Functions |