=ROUND((LEN(D4)=0)*($G$4+$G$4*20%)+(LEN(E4)=0)*($G$4+$G$4*10%)+(COUNT(D4:E4)=0)*(F4*86400),0)
12:20:30-12:22:43.34= 02:13.34
start finish elapsed
133.??
points
How can I edit the above formula, so that the points column shows the split, instead of rounding off the figure. So that i would show (133.34). Points are just converted elapsed times
This message was edited by thare on 2002-04-11 08:26
12:20:30-12:22:43.34= 02:13.34
start finish elapsed
133.??
points
How can I edit the above formula, so that the points column shows the split, instead of rounding off the figure. So that i would show (133.34). Points are just converted elapsed times
This message was edited by thare on 2002-04-11 08:26