Hi.
I am creating an excel spreadsheet for a race. the results are based on the following conditions :
For early arrival, 1 minute penalty per minute early
For late arrival, 10 seconds penalty per minute late
For checking on time, No penal
For late arrival of more than 30mins, the penalty is "OTL"
My columns are as follows :
Column E = Time Intended To Arrive
Column F = Time IN
Please help me with one formula (hh:min:sec) which would calculate the above penalties
Thanks in Advance
Cyran Ojola