
Enables / disables the automatic correction of time values within the time column. The correction is applied as soon as the text cursor is set to another cell, either by clicking somewhere or pressing the return key.
You can (mis)use this function to quickly convert values consisting of units that do not fit the time format. For instance, you could enter ",,900" which means 0 hours, 0 minutes, 900 seconds and 0 milliseconds and which is converted automatically to "00 : 15 : 00 : 000".
If you use floating-point or integer numbers, and you do not everytime want to disable the function, append an "f" to the number (e.g. "8274f") which means that the number is now protected against automatic conversion.
|