How to Convert Milliseconds to Seconds in Excel (2 Quick Ways)

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.


Download Practice Workbook

You can download our practice workbook from here for free!


2 Quick Ways to Convert Milliseconds to Seconds in Excel

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.

Sample Dataset to show how to Convert Milliseconds to Seconds in Excel

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.

Use Excel Division Feature to Convert Milliseconds to Seconds in Excel

  • 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.

Drag Fill Handle Downward to Copy Same Formula

As a result, you will get all the seconds’ values converted from the milliseconds’ values. For example, the outcome should look like this.

Converted Milliseconds to Seconds in Excel

Read More: How to Convert Minutes to Seconds in Excel (2 Quick Ways)


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.

Copy Millisecond Values

  • Following, right-click on the C5 cell and choose the Paste Values option from the context menu.

Paste Millisecond Values

  • At this time, write 1000 in another cell (D5 here).

Put 1000 in the D5 cell

  • Now, right-click on the D5 cell.
  • Subsequently, choose the Copy option from the context menu.

Copy the Cell Value

  • 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.

Using Paste Special Feature to Convert Milliseconds to Seconds in Excel

  • 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.

Paste Special Window

As a result, you will see all the millisecond values are converted to second values. And, for instance, the result would look like this.

Converted Milliseconds to Seconds in Excel

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))

Using Necessary Functions to Convert Milliseconds to Time in Excel

🔎 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.

Dragging Black Fill Handle Below to Copy Same Formula

Consequently, all the millisecond values will be converted into time values in Excel. And, the output would look like this.

Converted Milliseconds to Time in Excel

Read More: How to Convert Seconds to Hours Minutes Seconds in Excel


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.

And, visit ExcelDemy to learn about many more Excel problem solutions, tips, and tricks. Thank you!


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo