Calculating Penalties

I am calculating penalties for a road race. The penalties are applied as follows :

For every minute LATE, the penalty is 10 seconds
For every minute EARLY, the penalty is 1 minute
For lateness exceeding 15 minutes, the penalty/result is OTL
For arriving on time, the penalty is 0:00:00

column A = time out
column B = time allowed
column C = intended time
column D = time in
column E = penalty

Please provide formula to calculate the penalty in column E

Thank you for the reply

1) The format is in hh:mm:ss

2) penalties are calculated as follows :

time in - intended time

PS : how do i upload the sample worksheet

Regards

I hope the sample worksheet file named Penalties is attached now

the penalties dont follow your logic
line 8 15 minutes early, so penalty is 15 minutes, but you have 2:30?
line 9 14 mnutes early is OTL, not 14 minutes
line 10 10 minutes early is OTL not 10 minutes

Im not clear what you are asking!

Dear Sir,

I am really sorry for the overlook. Thanks for pointing out.

The time in should be :

line 8 = 10:45
line 9 = 10:46
line 10 = 10:50

sincere apologies