View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
build build is offline
external usenet poster
 
Posts: 22
Default Adding Fractions of a Second

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