Forum Discussion
Converting a number of a format (2:16) into minutes and seconds
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!
SergeiBaklan wrote: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.
Dear SergeiBaklan,
I am so thankful to you. Honestly, I wasn't even sure anyone would even reply to my message!
Thanks so much for taking out time and replying to me - your solution worked beautifully!
I am smiling ear to ear as I thank you :)
God bless!
Jayant, you are welcome
