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

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

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

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

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

<< Go Back to Time Conversion | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Tanjim Reza

Md. Tanjim Reza Tanim, a BUET graduate in Naval Architecture & Marine Engineering, contributed over one and a half years to the ExcelDemy project. As an Excel & VBA Content Developer, he authored 100+ articles and, as Team Leader, reviewed 150+ articles. Tanim, leading research, ensures top-notch content on MS Excel features, formulas, solutions, tips, and tricks. His expertise spans Microsoft Office Suites, Automating Finance Templates, VBA, Python, and Developing Excel Applications, showcasing a multifaceted commitment to the... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF