How to Set Time in Milliseconds?

When formatting time from hours and seconds, to more advanced format like h:m:s.ms, we should do it in a step-by-step format.

Click on an empty cell.

empty cell

Type =TIME(hour:minute:seconds)

time formula

Right click on the result (1), and choose format cell (2).

format cells

Choose custom (1), write hh(tt in this case):mm:ss,000;@ in the field under type (2), and press ok (3).

custom format cells

The Time format would now look like this:

milliseconds cell format