Excel performance calculations in milli- and microseconds

[Gregor Gisler]

Hi
I did a lot of calculations with performance measurement data. I was able to do the calcs, but ask myself whether there is no smarter way.
For example I use the following formula to subtract java style timestamps:
=(TIMEVALUE(MID(N3;1;8))+1.15740740740741E-08*MID(N3;10;12))
-(TIMEVALUE(MID(K3;1;8))+1.15740740740741E-08*MID(K3;10;12))

where N3=19:19:19,123 ->Formatted as text
and K3=20:20:20,321 ->Formatted as text
and 1.15740740740741E-08 is the internal Excel representation of a
millisecond

The result field is defined as Custom field: hh:mm:ss.000
This works fine. You even can calculate microseconds. My question:
Is there a better way to handle issues like this?
Thanks.
Gregor Gisler

 

[Andrew Poulsom]

Re: Excel performance calculations in milli- and microsecond

Welcome to the Board.

This:

=SUBSTITUTE(A1,",",".")+0

will convert the text entry to a serial time value. Format the results as hh:mm:ss.000.

 

[fairwinds]

Re: Excel performance calculations in milli- and microsecond

Hi,

seing the semicolons in Gregor's formulas, I guess comma could be the decimal separator for him. In that case you should not substitute, just try the =A1+0 part.