Calculating split times

thare · Apr 11th, 2002, 05:06 AM

=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 · Apr 11th, 2002, 05:29 AM

Quote:

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 · Apr 11th, 2002, 06:48 AM

Thanks Ivan

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 05:06 AM	#1
thare New Member Join Date: Apr 2002 Posts: 13	=ROUND((D4-E4)(-243600),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.

Apr 11th, 2002, 06:48 AM	#3
thare New Member Join Date: Apr 2002 Posts: 13	Thanks Ivan =ROUNDDOWN((D4-E4)(-243600),2) worked instead