On 2002-04-10 11:37, thare wrote:
Dear Aladin.
Thanks for your reply, also thanks to the other that replied. You said that the formula that you gave to me can be expressed in a IF formula.
My meaning:
That if there is NO start but there is a finish time or (the other-way around), the calculation can assume 10% or 20% of the slowest time in the group.
Yes, the Boolean formula does that. The precondition is, as I stated: Don't enter a finish time (leave the cell empty) when the stage/course is not completed. If a participant fails to start the stage, don't enter a start time (leave the target cell empty). The formula will do the rest. By the way, it computes directly the elapsed time in seconds.
(e.g) below
8:30:30 - 8:32:41.00 =02:11.00 131
8:30:30 - 8:32:41.56 =02:11.56 132
8:32:00 - 0:00:00.00 =00:00.00 0
9:24:00 - 9:26:45.01 =02:45.01 165
start finish elapsed points
Can it calculate and elapsed for the one that doesn't have a time, base on the slowest time (02:45.01) in the group.
Whether it is 10% or 20%.
With respect to the sample data above: it computes for the third participant not a 0, but
=165+165*10%
because 165 is the slowest time to which it adds the penalty of 10%.
If you want, I can send you the workbook that includes the formulas I proposed.
Aladin