How to Format Time to Milliseconds in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on March 28, 2023

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

AI Formula Generator

Try for Free

See all How-To Articles