Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Convert Time to Decimal Over 24 Hours in Excel?
In Excel, you may need to convert times that are longer than 24 hours to decimal to facilitate our understanding. For example, 25:00:00 will be represented as 25. Manually completing this task can be a time-consuming process. Read this tutorial to learn how you can convert time to decimal over 24 hours in Excel.
We can complete this task using a simple formula in Excel. Using the method described in this tutorial can save you a lot of time while providing the most accurate results. Even though there is no direct formula to complete the task, we can create our own formula based on our requirements and logic using some simple tricks.
Converting Time to Decimal Over 24 Hours in Excel
Here we will first get one result using the if statement and get all the other results using the auto-fill handler. Let us look at a simple procedure for converting time to decimal over 24 hours in Excel using formulas.
Step 1
Let us consider an Excel sheet where the data in the list of times over 24 hours is similar to the below image.
Firstly, click on an empty cell (in our case, cell B2) and enter the formula as
=IF(A2>TIME(24,0,0),TEXT(A2,"[h]:mm:ss")*24,A2) and press enter to get our first result, which looks like the image below. In the formula, A2 is the address of the cell where our time is present on the sheet, and we are multiplied by 24 because we need to convert the time to hours.
Empty cell > Formula > Enter
Step 2
Now drag down from the first result using the auto-fill handle to get all the results, and our final output will be similar to the below image.
Conclusion
In this tutorial, we used a simple example to demonstrate how you can convert time to decimal format in Excel.
831 Views
