How long does it take mars to axis? It takes any planet one day to rotate on its axis. A Martian day is only slightly longer than an Earth day: 24 hrs. 39 mins. 35 secs.
2. Divide the number of seconds by 60 to convert seconds to minutes. Every 60 seconds a full minute has passed. Dividing a number tells you how many times one number fits in the other.
Summary. To automatically format times that when added together exceed 24 hours, 60 minutes, or 60 seconds, you can use the following custom number formats and the SUM function in Excel: 1  Hours = [h]:mm:ss. 2  Minutes = [m]:ss. In the Category list, click Custom. 2  In the Type box, edit the number format codes to create the format you want. 3  For the minutes format, type [m]:ss. 4  For the seconds format, type [ss]. 5  Select the formatting that you want to apply, and then click OK.