Forum Discussion
Converting a number of a format (2:16) into minutes and seconds
My Dear Friends, I have been struggling for almost half a day (!) now to convert some number that my team sends me, in excel, which are in the format like 2:16 or 1:07 etc. These are the minute...
Hi Jayant,
If you'd only like to calculate the average you may use
=AVERAGE(<you cells>)*24*60
which will return the average in seconds.
I want to go the other way, example given: I have number of seconds in my case, the average number of seconds to cover 5oo meters rowing: i.e. 160 seconds, need to be converted into a format: mm:ss, leading to 02:40 164 seconds leading to 02:44
In Excel actually days are integers and time is decimal part of the number. In calculations one day is equal to 1, thus one hour = 1/24; one minute = 1/24/60 and one second = 1/24/60/60. With that you may do conversions from numbers to time and back, just apply proper format where necessary. Your sample:
SergeiBaklan one wishes life will always be so easy, super, it is not just the formula that helped, but also the way approaching the problem, Thanks very much!
jjrtoussaint-nl , you are welcome