Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

Add Milliseconds to Time in Excel (with Quick Steps)

This article illustrates how to add milliseconds to time in excel. The available time formats in excel are enough for most cases. But assume you are the game teacher in your school. Then you may need to work with milliseconds and add or subtract them. How will you do it? Well, although there is no in-built time formatting for milliseconds, there is a way around doing this. Follow the article to learn how to do that.


Download Practice Workbook

You can download the practice workbook from the download button below.


Steps to Add Milliseconds to Time in Excel

Assume you have the following dataset. Now you need to add the millisecond values in column C to the time values in column B and get the results in column D.

dataset to add milliseconds to time in excel

Follow the steps below to be able to do that.


STEP 1: Apply Formula to Add Milliseconds to Time

  • First, enter the following formula in cell D5. You can replace the values within brackets with 86400000. The values within brackets represent 24-hr in a day, 60-min in an hour, 60-seconds in a minute, and 1000 milliseconds in a second.
=B5+C5/(24*60*60*1000)

Formula to add milliseconds to time

Read More: How to Add Minutes to Time in Excel (3 Quick Methods)


STEP 2: Change Cell Formatting to Show Milliseconds

  • Then press CTRL + 1 to open the Format Cells dialog box. Next, go to the Custom category from the Number tab. After that, enter hh:mm:ss.000 in the Type field to apply this formatting with milliseconds. Then click OK.

Format cell as hh:mm:ss.000

NOTE: You should apply [hh]:mm:ss.000 formatting instead of hh:mm:ss.000 in case of elapsed time to get the hour value past 24.

Read More: How to Add Hours to Time in Excel (8 Quick Ways)


Similar Readings


STEP 3: Copy Formula Using Fill Handle

  • Finally, double-click on the Fill Handle icon or drag it to the cells below to add all the millisecond values to the respective time values.

Copy formula using fill handle

Read More: How to Add Minutes and Seconds in Excel (3 Easy Methods)


Things to Remember

  • You should apply [hh]:mm:ss.000 formatting instead of hh:mm:ss.000 in case of elapsed time to get the hour values past 24.
  • The formula bar in excel won’t show the added milliseconds as it is designed that way.

Conclusion

Now you know how to add milliseconds to time in excel. Do you have any further queries or suggestions? Please let us know in the comment section below. You can also visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo