Hi
I have a problem with a car race i'm trying to time.
I have got the net time with a time formatted cell. Though they may incur penalties that add 10secs onto the net time.
I have created a column with the number of penalties but am struggling to convert these into a time format to then add to the overall time? At moment i'm inputting it manually but am after a formula or format to convert it automatically?? I've attached my current sheet and highlighted column. There is a 10sec penalty for each flag hit.
Thanks in advance!
Bookmarks