Forum Discussion
Time conversion
Hello I have a list of time in the format 00:15, meaning 0 minuts and 15 seconds followed by a value in the second cell. I have to construct a graph with time as X-axes and value in Y-axes. When th...
By default, 00:15 is 0 hours and 15 minutes. You have to enter 0 minutes and 15 seconds as 00:00:15, even if you only display the minutes and seconds.
If you really meant 0 minutes and 15 seconds, apply the custom number format [mm]:ss
This allows the minutes to be above 59.