# Add Milliseconds to Time in Excel – 3 Steps

This is the sample dataset. To add millisecond values in column C to the time values in column B and get the results in column D:

### STEP 1 – Apply a Formula to Add Milliseconds to Time

• Enter the following formula in D5.

You can replace the values within brackets with 86400000. These values represent 24 hours in a day, 60 minutes in an hour, 60 seconds in a minute, and 1000 milliseconds in a second.

`=B5+C5/(24*60*60*1000)`

Read More: How to Add Minutes to Time in Excel

### STEP 2 – Change the Cell Formatting to Show Milliseconds

• Press CTRL + 1 to open the Format Cells dialog box.
• In the Number tab, go to Custom.
• Enter hh:mm:ss.000 in Type.
• Click OK.

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

### STEP 3 – Copy the Formula Using the Fill Handle

• Double-click the Fill Handle icon or drag it down to see the result in the rest of the cells.

Read More: How to Add Minutes and Seconds in Excel

Download Practice Workbook

Download the practice workbook.

## Related Articles

<< Go Back to Add Time in Excel | Calculate Time | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF