Milliseconds in Excel
We all know
how to calculate difference in time: in hours, minutes and seconds.
But did you
know that you can compute time with milliseconds in Excel as well?
In order to
calculate milliseconds, you first need to format the number properly.
This won’t do:
Pic 1: we cannot subtract times with milliseconds…
So how do we
do it?
First, we need to convert the data structure.
The last (third)
colon :
must be converted into a dot .
This can
easily be accomplished with the SUBSTITUTE function, as can be seen in cells D2
& E2.
Pic 2: changing the data
Next, we have to format the Start time, End time and the Difference as can be seen in this screenshot:
Pic 3: changing the number
format
And, now in
cell G2 we get the correct result, in hours, minutes, seconds and milliseconds:
Pic 4: the desired result with milliseconds
אין תגובות:
הוסף רשומת תגובה