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.
To convert seconds in decimal format to a proper Excel time, just divide by 86400. For example, if you have a number that represents seconds in cell A1, use: If A1 contains the number 21600 (representing 21600 seconds) then the result will be 21600/21600 = .25, since 21600 minutes = 6 hours = 1/4 day.o display hours that represent a duration longer than 24 hours, minutes in durations longer than 60 minutes, or seconds in durations over 60 seconds, you'll need to adjust the number format by adding square brackets. The brackets signal to Excel that the time is a duration, and not a time of day.