Adding and Subtracting a Time with MilliSeconds
Hmmm... you give two different formats.
If they come in as milliseconds:
10:39:41.001
(.01 would be centiseconds, and :01 is something else entirely), then
A1: 10:39:41.91 (or 10:39:41.910)
A2: 10:39:54.01 (or 10:39:54.010)
use
A3: = A2 - A1
and format A3 with Format/Cells/Number/Custom hh:mm:ss.00 (hh:mm:ss.000)
In article ,
carl wrote:
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.
|