If you have a series of values like this:
12.5
9.3
10.7
and want to convert this numbers to a minutes/seconds format you can use this formula:
=A1/(24*60)
This assumes that the values below are on cells A1:A3 and this formula is placed on cell B1 and copied down. You need to format the cells B1:B3 as Custom mm:ss to see this:
12:30
09:18
10:42
2 comentários:
This does not work for segments of time larger than 24.
Thanks for posting this information it really useful for everyone.
French Classes in Chennai
french courses in chennai
Spoken English Classes in Chennai
TOEFL Coaching in Chennai
pearson vue test center in chennai
German Language Course in Chennai
IELTS Coaching in anna nagar
ielts coaching in chennai anna nagar
Post a Comment