How to show time with milliseconds in Excel

preview_player
Показать описание
For example a recorded time contains milliseconds, such as 10:33:50.235. When I type this time into a cell in Excel, the time shows as 33:50.2. After changing to the time format, the time shows as 10:33:50 AM with milliseconds disappearing. Is there any way to show time normally with remaining milliseconds in Excel? Yes, the following method will help you solve it easily.

More details:
Рекомендации по теме
Комментарии
Автор

I am trying this: "hh:mm:ss.000" and getting error: "Microsoft Excel cannot use the number format you typed."

PedronesBR