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 ...
Your sample data is inconsistent - seconds for the first two entries, and minutes and seconds for the last entry. To get seconds stored as an Excel time value, you'll need to divide them by 86400 (the number of seconds in a day). Then you can apply a custom format [s].000 or [ss].000 (or [mm]:ss.000 for your alternative).
Note that if your time data has a value like 01:18 (including the colon, but omitting the decimal portion), it will be interpreted as hours and minutes instead of minutes and seconds. For such a value you would have to divide by 60.