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.
SergeiBaklan wrote:Hi Jayant,
If you'd only like to calculate the average you may use
=AVERAGE(<you cells>)*24*60which 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