Hi,

I am sorry if this is a simple, easy answer but I havent been able to work it out. I am completing some time trial sheets and need some help.

I am given a trial time winner information as minute-seconds.milliseconds eg- 3-23.8 (3 mins 23.8 seconds). I am then given the other runners time of how many seconds they were off the leader eg. 1.2 seconds. I want to be able to give a total time for each runner eg - 3-23.8 + 1.2 seconds therfore total of 3 mins and 25 seconds.

I am having trouble getting excel to recognise the minute-seconds.milliseconds eg- 3-23.8 as a 'time' and then being able to add the x.x seconds onto it? Can anyone help me out with this?


Thanks