Hi
I need a single combined formula (hh:mm:ss) to calculate penalties for a race whose conditions are :
For EARLY arrival, the penalty is 1 minute per minute early
For LATE arrival, the penalty is 10 seconds per minute late
For arrival ON TIME, the penalty is NIL
For LATE arrival in excess of 30 minutes, the penalty is OTL
An example is below :
time out = 10:00
time allowed = 30 minutes
time to be IN = 10:30
time IN = 10:29
penalty = 0:01:00 being 1 minute early
time out = 10:00
time allowed = 30 minutes
time to be IN = 10:30
time IN = 10:31
penalty = 0:00:10 being 1 minute late
time out = 10:00
time allowed = 30 minutes
time to be IN = 10:30
time IN = 10:30
penalty = 0:00:00 on time
time out = 10:00
time allowed = 30 minutes
time to be IN = 10:30
time IN = 11:01
penalty = OTL being exceeding lateness of 30 minutes
your assistance will be appreciated
thanks
Cyran
Bookmarks