Just add them

Assume the values are in A

=A1+"0:0:0.150"

use the same format as before

or put the fractions in another cell and add the cells

you can also use

=150/86400/1000

or

=150/24/60/60/1000

equals 0:00.15

so

=A1+(150/24/60/60/1000)


--

Regards,

Peo Sjoblom





"build" wrote in message
...
G'day All,
I have a table of times in the format m:ss.000 i.e.
1:26.072
1:26.493
1:26.556
1:26.755

I want to add fractions of a second to these times. i.e. 1:26.072 +
0:00.15
I have tried the TIME() function but it does not work with fractions of a
second.

Thanking you in anticipation,
build