Often you may want to convert seconds to hours in Excel.
There are two common ways to do so:
Method 1: Convert Seconds to Decimal Hours
For example, 4,350 seconds will be shown as 1.208 hours.
Method 2: Convert Seconds to Hours, Minutes, Seconds
For example, 4,350 seconds will be shown as 1 Hour, 12 Minutes, 30 Seconds.
The following examples show how to use each method in practice with the following dataset in Excel that shows the number of seconds that it took for various athletes to finish some task:
Example 1: Convert Seconds to Decimal Hours
If you’d like to convert seconds to decimal hours then you can simply divide the number of seconds by 3,600, which represents the number of seconds in one hour.
For example, we can type the following formula into cell C2:
=B2/3600
We can then drag and fill this formula down to each remaining cell in column C:
Column C now displays the number of seconds in column B in terms of decimal hours.
For example:
- 2,220 seconds is equal to 0.611 hours.
- 4,350 seconds is equal to 1.208 hours.
- 140 seconds is equal to 0.039 hours.
And so on.
Example 2: Convert Seconds to Hours, Minutes, Seconds
If you’d like to convert seconds to hours, minutes and seconds then you must first divide the number of seconds by 86,400, which is the number of seconds in one day.
For example, we can type the following formula into cell C2:
=B2/86400
We can then drag and fill this formula down to each remaining cell in column C:
Next, highlight the cells in the range C2:C11, then click the Number Format dropdown menu from the Home tab, then click More Number Formats:
In the new window that appears, click Custom in the Category list, then type [hh]:mm:ss in the Type window, then click OK:
Once you click OK, the cells will automatically be formatted as hours, minutes and seconds:
For example:
- 2,220 seconds is equal to 36 minutes and 40 seconds.
- 4,350 seconds is equal to 1 hour, 12 minutes and 30 seconds.
- 140 seconds is equal to 2 minutes and 20 seconds.
And so on.
Additional Resources
The following tutorials explain how to perform other common operations in Excel:
Excel: How to Convert Time Duration to Minutes
Excel: Calculate Difference Between Two Times in Minutes
Excel: Calculate Difference Between Two Times in Hours