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 Milliseconds to Time in Excel?
If the data in the sheet is given in milliseconds, then it can be very confusing, and you will not be able to perform any operations on it as it will be a very large value. Generally, one millisecond is equal to 1/1000 second. If we need to find the duration from the milliseconds, we can use this process.
This tutorial will help you understand the process of converting milliseconds to time in Excel. If you try to do it manually, it will be time-consuming and inaccurate. So, in this tutorial, we will try to convert milliseconds to duration using the formulas. Even though there is no direct formula available, we can create one just by understanding our data.
Converting Milliseconds to Time in Excel
Here, we will first get any one of the results using the CONCATENATE formula and then use the auto-fill handle to complete the process. Let's go over a simple procedure for converting milliseconds to time in Excel using formulas.
Step 1
Let us consider an excel sheet where the data is durations, which are represented in milliseconds, similar to the below image.
Now, in our case, B2, click on an empty cell and enter the formula as follows −
=CONCATENATE(TEXT(INT(A2/1000)/86400,"hh:mm:ss"),".",A2-(INT(A2/1000)*1000)) And click Enter to get our first result, which looks similar to the below image. In the formula, A2 is the address of our values on the Excel sheet.
Empty cell > Formula > Enter
Step 2
Now to get all the results, drag down from the first result using the auto-fill handle until all the results are filled, and our final result will be similar to the below image.
Note − In the formula, we first divide the value by 1,000 to convert it to seconds, and then divide it by eight thousand and four hundred to convert it to time because every day has eight thousand and four hundred seconds, and we can use the format hh:mm if you don’t want to display seconds.
Conclusion
In this tutorial, we used a simple example to demonstrate how we can convert milliseconds to time in Excel.
6K+ Views
