See all How-To Articles

How to Format Time to Milliseconds in Excel

In this tutorial, you will learn how to format time to milliseconds in Excel.

 

format time milliseconds initial data

 

Format Time to Milliseconds

Say you have the time values below in Excel with hours, minutes, and seconds displayed, and you want to show milliseconds as well.

 

format time milliseconds initial data

 

Follow these steps to create a custom time format that displays milliseconds:

  1. Select the cells with times (B2:B8) and right-click anywhere in the selected area. Then click Format Cells (or use the keyboard shortcut CTRL + 1).

 

format cells excel

 

  1. In the Format Cells window, go to the Number tab, select Custom from the Category list, and enter h:mm:ss.000 in the Type text box.

 

format cells milliseconds

 

As a result, all of the time values are displayed with milliseconds as decimals.

 

time cells formatted with milliseconds