ok, thanks. that'll be good enough. i figured it was some excel limitation.

--


Gary


"Ron Rosenfeld" wrote in message
...
On Sun, 12 Aug 2007 15:51:12 -0400, "Gary Keramidas" <GKeramidasATmsn.com
wrote:


thanks. don't know what i'm doing wrong, but when i set the start time to now,
and the end time to now and then subtract, i get something like this:
8.10185156296939E-05
when i try to format the output like you suggested, i get zeroes.

When I format your value: 8.10185156296939E-05 as [s].000 I get 7.000
(seconds)

That is precise to three decimal places, which is as good as you will get
using
a time format.

If you want more precision than thousandths of a second is required (and that
might be the case if you have very very accurate time determining techniques),
then you should not be using Excel time format.

Excel stores time as a fraction of a day. So 8.10185156296939E-05 is equal to
6.999999750405550 seconds. Rounded to thousandths of a second, it is 7.000
seconds.
--ron