Milliseconds and Hundredths of a second
Today, we want to learn how to show a hundredth of a second or a milliseconds in Excel.
Let’s start by writing our time in a cell. Let’s assume that we want 0 minutes, 12 seconds and 45 milliseconds. Let’s enter it in our cell. We can see that we have two places for minutes and only one digit after it. It’s not a hundredth of a second, but it’s only a starting point. Since we’re working with time, a simple Increase Decimal option wont’ work here, as they’re not real numbers. Let’s press Ctrl + 1. It will take us to the Format Cells window. We are in the Number tab, Custom Category, where the custom format is mm.ss.0. We can see that the decimal part is only one 0 (Fig. 1)
Let’s add two more zeros. Three zeros is the maximum number of decimal places for time (Fig. 2)
Now, we have more precise time (Fig. 3)
We can do the same with other cells. We can even add hours (Fig. 4)
However, in our case we don’t need it. Let’s test our setting and write 00:45.670 in the next cell, and 00:00.001 in another one. We can see that Excel is showing the time precisely. Now, let’s add it all up and check if the result is also precise (Fig. 5)
=SUM(C2:C5)
Here we go, the time is precise also in this case.