Brave Chief

[Shaun]

Hey mate i found a nice solution to your problem with the time formating if you are interested

=SUBSTITUTE(A1,":",".")/-86400

then set formating to custome ss.00

[brave chief]

cheers shaun, will check it out and see how it goes :)

[Sportz]

What the....? I sure hope you understood that Brave Chief.

[Shaun]

=SUBSTITUTE(A1,":",".")/-86400
quick explination= in cell A1 we have this(35:23) this is formated to text or general not time
so the formula is saying change this > : < for this > . < now i don't understand this myself but deviding the number by -86400 creates a time format then he goes to formating and select custom and adds this setting
s=seconds s=seconds > . < 0=milliseconds 0=milliseconds
once this is done the result will be 35.23 in time format that allows addition and sutraction

[Sportz]

Yeah. Clear as mud.