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 ...
As variant that could be
=IF( B3<1/24, B3, TIMEVALUE("0:" & TEXT(B3, "@")) )on such samle
and apply mm.ss.000 format