Hi Ted
SUBSTITUTE is a text function and so the result is text. You don't want the result 00:01:54.83 to be text, just a bunch of characters, what you want it to be is excel time.
To convert text to excel time you can do it explicitly, with the timevalue function:
=TIMEVALUE(SUBSTITUTE(A1,":",".",3))
or use a property of excel that is type coercion. Excel "tries hard" to calculate the result of a formula. If the types of the operators are not the adequate for the operation excel tries to convert them to the appropriate types.
That's what we are doing. When we add 0, excel sees the operator + and knows that it expects 2 numbers. Since the first is a text excel converts it to number. It then adds 0 which doesn't change the value.
So adding 0 to a text is a convenient way of converting it to number.
Hope it's clear
PGC