Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 22

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
fractions	NILELATOR	Excel Worksheet Functions	5	December 2nd 06 09:35 PM
Fractions	Angel1	Excel Discussion (Misc queries)	4	October 18th 06 06:54 PM
Fractions	phil2006	Excel Discussion (Misc queries)	1	July 6th 06 11:36 AM
Fractions	Andy	Excel Discussion (Misc queries)	1	May 11th 06 05:02 PM
Fractions	V	Excel Discussion (Misc queries)	5	September 14th 05 04:00 PM

All times are GMT +1. The time now is 02:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us