Hi,

My code currently locates a cell depending on the information entered, that will hopefully be the cell containing the time value. However, this is not always the case, which is one of the problems. The time data will always be in a different column but on the same row.

Also, once the time value is found, it is usually formatted differently each time. The 2 common formats I've found are mm:ss.0 eg. 01:33.2 and text(string) eg. 1-33.2. I need to be able to convert both these forms to a decimal value which represents the total seconds. eg 1:33.2 = 93.2. To then perform the simple subtraction at the end of the code.

Please Login or Register  to view this content.
Can anyone solve these 2 problems I have. Any help would be greatly appreciated.

Yappa