Forum Discussion
Time formatting - minutes, seconds and milliseconds
Hello, Any suggestion how to user Format Cells - Custom time format in the following scenario? As example, I have following data imported to excel: 42.336 51.858 01:17.9 This ...
I think a format of
= TEXT(time, "hh:mm:ss.000")should work, either within a TEXT statement (as shown) or applied directly to the cell as a custom number format.