How to Convert Clock Time to Seconds

When it comes to working with clock times in Microsoft Excel, converting them to a decimal number can be a useful skill. This article will demonstrate three different formulas for converting hours from the standard time format (hh:mm:ss) to a decimal number.

One of the simplest ways to convert time to seconds is by multiplying the time value by 86400, which is the number of seconds in a day (24*60*60). To do this, you can use the following formula:

=Time Value * 86400

For example, if your time value is 1:30:45, you would multiply it by 86400 to get the equivalent number of seconds.

Another way to convert time to minutes is by multiplying the time value by 1440, which is the number of minutes in a day (24*60). You can use the following formula:

=Time Value * 1440

Finally, you can also convert time to a decimal number by multiplying it by 24, which is the number of hours in a day. This can be useful if you need to perform calculations involving times.

Overall, there are three ways to change a time value to a decimal number: arithmetic operation, CONVERT function or a combination of three different Time functions (HOUR, MINUTE and SECOND). By using these formulas, you can easily convert clock times to seconds, minutes or hours in Microsoft Excel.

Convert clock time to seconds