Thorostats Par Times importing to Excel

[griz]

When Thorostats Par times come into Excel, any time greater than 1 minute has to be changed by hand to seconds. Does anybody know of an Excel add-in can which easily convert these times. I can import a whole Trackmaster race card into Excel and instantly convet every time to seconds, but with Thorostats I can't do anything with them.

[sjk]

Don't know anything about these particular files but to convert times in Excel I used to use the find function to locate a colon.

If it returned a number I multiplied the value of the string to the left of the colon by 60 and added it to the value of the string to the right of the colon.

If the find returned error just use the value of the string.

p4= time string

p7=find(":",p4,1)

time in secs=IF(ISERR(P7),VALUE(P4),60*VALUE(MID(P4,1,P7-1))+VALUE(MID(P4,P7+1,5)))

[griz]

Thanks for the prompt reply. I'm not a Visual Basic programmer or any other type for that matter. So your answer is above my pay grade.

[Murph]

See if this info can help you.


http://support.microsoft.com/default.aspx?kbid=214094&product=xl2002

Murph

[tboles]

Griz asks:
When Thorostats Par times come into Excel, any time greater than 1 minute has to be changed by hand to seconds

Griz, we have updated the pars to show in either mins or seconds without the need to convert. Members choice....