Converting time in hh:mm:ss format to decimal format

[shanekerr]

Hi guys, so I've got quite a big data set of timed results that I need to convert from being in "hh:mm:ss" format to a decimal format so that it is amenable to stats.

I've attached an example. In it I've manually entered in the hours, minutes and seconds and then inserted a simple calculation. The problem is that on a large scale this will be too time consuming.

Any ideas/help?

Cheers

Shane