Forum Discussion
Jayant Bakshi
Jun 07, 2018Copper Contributor
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...
jjrtoussaint-nl
Oct 27, 2020Copper Contributor
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
Oct 27, 2020Diamond Contributor
jjrtoussaint-nl , you are welcome