Calculating split times

[thare]

=ROUND((D4-E4)*(-24*3600),0)
(e.g)
8:30:00 - 8:32:32.09= 02:32.09 152.0
start finish elapsed points

The above formula is rounding off split times in the example given to the nearest whole number.

Is there another formula that calculates the split so it can read ( 159.09 ). Instead of rounding it off the the nearest whole number.

 

[Ivan F Moala]

On 2002-04-11 04:06, thare wrote:
=ROUND((D4-E4)*(-24*3600),0)
(e.g)
8:30:00 - 8:32:32.09= 02:32.09 152.0
start finish elapsed points

The above formula is rounding off split times in the example given to the nearest whole number.

Is there another formula that calculates the split so it can read ( 159.09 ). Instead of rounding it off the the nearest whole number.

Try

=ROUNDDOWN((D4-E4)*(-24*3600),1)

 

[thare]

Thanks Ivan

=ROUNDDOWN((D4-E4)*(-24*3600),2)
worked instead