Jul 14 2018 02:31 PM
I'm developing a spreadsheet in Excel 2016 (Office 365, Version 16.0.7167.2055). I want to find out how to convert an number in a cell that represent a quantity in "seconds" that I want to convert to display as "minutes : seconds" but don't know the custom Number Code to make that happen. For example, the number in the cell is 65.6631951100942 and I want to have it display as 01:06 (one minute : 6 seconds). Using Excel Help, it says to do that I should use the Custom Number Code [mm]:ss, but when I do that it returns 94555:00 (which I’ve determined this represents the number of seconds in ~65.66 days, i.e. 65.66d*24hr*60min). I’ve tried other custom codes without success.
Jul 14 2018 07:41 PM
SolutionHi Jerry,
Please try this formula:
=TEXT(TIME(0,0,ROUND(A1,0)),"[mm]:ss")
Regards
Jul 14 2018 10:07 PM
Jul 15 2018 06:30 AM
Keep learning and with practice, and you will become like me!
If you want a strong Excel foundation for free, I would advise you to follow this guy.
I learned a lot from him!
Regards
Jul 14 2018 07:41 PM
SolutionHi Jerry,
Please try this formula:
=TEXT(TIME(0,0,ROUND(A1,0)),"[mm]:ss")
Regards