In this tutorial, you will learn how to convert time into decimals in Excel.
How can you easily resolve the problem if you have a range of time or texts in Excel that are formatted in [HH:MM:SS] and you want to convert them to decimal hours, minutes, or seconds?
Once you are ready, we can start by using real-life scenarios to help you understand how to convert time into decimals in Excel.
Table of Contents
Convert Time into Decimals in Excel
Before we begin we will need a group of data to be used to convert time into decimals in Excel.
First, you need to have a clean and tidy group of data to work with.
To convert the time into decimals of hours, minutes and seconds, you can simply apply the following formulas:
Hour = *24 (as there are 24 hours in a day)
Minute = *1,440 (as there are 1440 minutes (24*60) in a day)
Second = *86,400 (as there are 86,400 seconds (24*60*60) in a day)
Once you multiply your time to the above numbers, you will get the decimals for each hour, minute or second.
Lastly, make sure the cells for the decimals are formatted to either ‘General’ or ‘Numbers’.