Excel Format Question

[andy28]

I download a lot of race results but the time comes in a format of 1.12.06 for example and also the sections come in the same format so will be 0.35.01. Is there a way to change the format into seconds so the above examples will be displayed 72.06 and 35.01?

I know you can change the date into a number so I am hoping you can turn time into seconds

TIA

[Shaung89]

Dirty method but put this formula in (assuming value in cell A1)

=CONCATENATE(SUM((((LEFT(A1,1))*60)),MID(A1,3,2)), ".", RIGHT(A1,2))

This will only work for races up to 9 minutes 59 seconds...

[andy28]

Dirty method but put this formula in (assuming value in cell A1)

=CONCATENATE(SUM((((LEFT(A1,1))*60)),MID(A1,3,2)), ".", RIGHT(A1,2))

This will only work for races up to 9 minutes 59 seconds...

That worked like a charm, I can''t thank you enough, bloody brilliant!!!!!

[Shaung89]

No worries, good luck!