Adding and Subtracting a Time with MilliSeconds
They look to me like centiseconds rather than milliseconds.
If you correct the first one where you've mistyped a colon instead of the
decimal point, then you can add as normal.
=A1+A2 will give you the answer.
If the answer may go beyond 24 hours, custom format something like
[h]:mm:ss.00
--
David Biddulph
"carl" wrote in message
...
My time comes in like this:
10:39:41:91
10:39:54.01
hours:minutes:seconds.milliseconds.
Is there a way to add and subtract times in this format ?
Thank you in advance.
|