How to Convert Hours to Seconds in Excel
Microsoft Excel allows users to convert between different time units using the Hour, Minute, and Second functions. The functions extract the appropriate corresponding piece from a stated time. You can then add on to the formulas with your own calculations to convert between units. For example, if you wish to convert minutes into seconds, you would need to multiply by 60 since there are 60 seconds per minute.
Other People Are Reading
Instructions
-
-
1
Open a new workbook in Microsoft Excel.
-
2
Enter the time in a blank cell such as 6:20:35 in A1.
-
-
3
Click on a blank cell and enter the following formula: =(HOUR(cell)*60*60)+(MINUTE(cell)*60)+SECOND(cell), where cell refers to the cell reference that contains the time. The formula extracts the hour, minutes, and seconds from the time. It multiplies the hours by 60 to convert into minutes, then multiplies by 60 again to get seconds. The minutes are multiplied by 60 to get the seconds, and the seconds are added to the calculation to get the total seconds.
For example, the formula =(HOUR(A1)*60*60)+(MINUTE(A1)*60)+SECOND(A1) would bring back 22,835 seconds.
-
4
Format the cell as general by right clicking on the cell and selecting the "General" category in the "Number" tab of the "Format Cells" window.
-
1
