Excel is a fantastic tool for handling time data and calculating times in different units. Time can be in days, hours, minutes, seconds, or milliseconds in an Excel file. Now, a millisecond is a tiny unit of time. Now, if you need to convert the millisecond values to seconds, you have come to the perfect place. In this article, I will show you 2 quick ways to convert milliseconds to seconds in Excel.
How to Convert Milliseconds to Seconds in Excel: 2 Quick Ways
Say, we have 6-time values in milliseconds. Now, we need to convert those in seconds. We can accomplish this target in any of the following ways given below.
In this article, we have used the Office 365 version of Microsoft Excel. But, no worries! You can use all of these ways in any Excel version available to you. If you face any problems regarding versions, please comment below.
1. Using Excel Division Feature
The easiest and quickest way to convert milliseconds to seconds in Excel is to use the Excel division feature. Follow the steps below to do this.
📌 Steps:
- First and foremost, click on the C5 cell and insert the following formula.
=B5/1000- Subsequently, hit the Enter button.
- Afterward, place your cursor on the bottom right position of the C5 cell.
- Subsequently, a black fill handle will appear.
- Following, drag it down to copy the same formula for all the other cells below.
As a result, you will get all the seconds’ values converted from the milliseconds’ values. For example, the outcome should look like this.
Read More: How to Convert Minutes to Seconds in Excel
2. Using Paste Special Feature
Another thing you can do is to use the Paste Special feature to convert milliseconds to seconds in Excel. Go through the steps below to do this.
📌 Steps:
- First and foremost, select the millisecond values (B5:B10 here).
- Afterward, right-click on your mouse and choose the Copy option from the context menu.
- Following, right-click on the C5 cell and choose the Paste Values option from the context menu.
- At this time, write 1000 in another cell (D5 here).
- Now, right-click on the D5 cell.
- Subsequently, choose the Copy option from the context menu.
- Last but not least, choose the C5:C10 cells and right-click on your mouse.
- Subsequently, choose the Paste Special… option from the context menu.
- As a result, the Paste Special window will appear.
- Following, at the Operation group, put the radio button on the Divide option.
- Subsequently, click on the OK button.
As a result, you will see all the millisecond values are converted to second values. And, for instance, the result would look like this.
Read More: How to Convert Seconds to Minutes in Excel
Convert Milliseconds to Time Format in Excel
Now, sometimes you might need to convert millisecond values to time values in Excel. To accomplish this, you need to use the CONCATENATE, TEXT, and INT functions. Follow the steps below to do this.
📌 Steps:
- At the very beginning, click on the C5 cell.
- Subsequently, insert the following formula and press the Enter button.
=CONCATENATE(TEXT(INT(B5/1000)/86400,"hh:mm:ss"),".",B5-(INT(B5/1000)*1000))
🔎 Formula Breakdown:
- =TEXT(INT(B5/1000)/86400,”hh:mm:ss”):
This takes the B5 cell’s value as input. Following, it divides it by 1000 and subsequently by 86400. Then it converts the integer result into text format in hours:minutes: seconds format.
Result: 12:44:32 - =B5-(INT(B5/1000)*1000):
This divides the B5 cell’s value by 1000 and then converts it into an integer. Following, it multiplies the result by 1000 and finally subtracts it from the B5 cell’s value.
Result: 0 - =CONCATENATE(TEXT(INT(B5/1000)/86400,”hh:mm:ss”),”.”,B5-(INT(B5/1000)*1000)):
This combines the first described result with a decimal point (.) and then combines the second described result here.
Result: 12:44:32.0
- Afterward, place your cursor on the bottom right position of the C5 cell.
- Next, drag the black fill handle below upon its appearance.
Consequently, all the millisecond values will be converted into time values in Excel. And, the output would look like this.
Read More: How to Convert Seconds to Hours Minutes Seconds in Excel
Download Practice Workbook
You can download our practice workbook from here for free!
Conclusion
So, in this article, I have shown you 2 quick ways to convert milliseconds to seconds in Excel. Read the full article carefully and practice accordingly. I hope you find this article helpful and informative. You are very welcome to comment here if you have any further questions or recommendations.
Related Articles
- How to Convert Minutes to Days in Excel
- How to Convert Minutes to Tenths of an Hour in Excel
- How to Convert Minutes to Hundredths in Excel
- How to Convert Minutes to Hours and Minutes in Excel
- How to Convert Seconds to Hours and Minutes in Excel
- Excel Convert Seconds to hh mm ss
- How to Convert Minutes to Decimal in Excel
<< Go Back to Time Conversion | Date-Time in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
