Adding Fractions of a Second

B

build

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
 
O

OssieMac

I think that your problem might be in the way you are entering the times. All
times must be entered as h:m:s.0 etc. If you want to enter .15 seconds then
enter it as 0:0:0.15.

You can set the format to display only minutes and seconds but you must
enter the hour when entering the value.

Regards,

OssieMac
 
P

Peo Sjoblom

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)
 
B

build

G'day Ossie,
Good name! You must be a great bloke. Ossie Ossie Ossie Oi Oi Oi. LOL
If I enter 1:26.493 and 0:00.150 in cells and add them it works well.
However if I want to do that in a formula I need to use =A3+TIME(0,0,0.15)
and that does not work.
Is that a bit clearer?

Thanks again in anticipation,
build
 
O

OssieMac

What I said before is semi right in that it will work. I just tested it and
you can enter just the minutes and seconds when you have a decimal after the
seconds. Example:-
1:26.15 is 1m 26.15secs and can be entered this way.

However, if you enter 1:26 then that becomes 1hr 26mins.

If you just enter .15 then that converts to 3hrs 36 mins.

0:0.15 is .15secs.

Regards,

OssieMac
 
O

OssieMac

And G'day to You.

Try this:-

=A3+VALUE("0:0:0.15")

Assuming that A3 is a time and the cell with the formula is also formatted
to time.

Regards,

OssieMac
 
B

build

That works.
Appreciate.
Oi!
build


OssieMac said:
And G'day to You.

Try this:-

=A3+VALUE("0:0:0.15")

Assuming that A3 is a time and the cell with the formula is also formatted
to time.

Regards,

OssieMac
Click to expand...
 
P

Peo Sjoblom

No need to use VALUE when you convert text in a calculation, the calculation
itself will take care of that, besides I posted this solution an hour
earlier


--

Regards,

Peo Sjoblom
 
Top