Thanks Iomaca for that. I just tried it and had to play with the last little bit a tad. It now works for:

=LEFT(L2,1)*60+MID(L2,3,2)+RIGHT(L2,3)

If I format the active cell to Number and 2 decimal places.

Thanks again, Paul

Not sure what that time represents maybe you could post an excel sheet with some copied data i could work on.

Web Queries are basically copying the data from the website directly in to excel, it would use the url of the page than download the web tables, you can download the whole page or only part of it, i will post example shortly.

Here is a simple web query just change the race code and race number and press "Get Race" there is a VBA code in the code section, i have a few sheets floating around this forum that will give you ideas on how to do things, if done right you should be able wo automate the tasks.

Attached Files

Test Query.xlsm (26.7 KB, 409 views)

Thanks Shaun, I shall have to sit down and study this tomorrow, see if I can fathom it out, maybe some more questions then,

Paul

With hindsight, if the time is always expressed in this format then this formula is simpler:

=LEFT(A1,1)*60 + MID(A1,3,4)
Cheers

Thanks Iomaca for your help in this. Been out all day (playing bowls) and just getting back into this spreadsheet now,

Paul

One of the problems I have encountered with the Unitab formguide, is that it shows the margin as,....eg,.."3.5L",....whether it won OR lost by 3 1/2 lengths,

hmm

that should not be a great problem if you also record the finishing pos and number of runners which is the far left cell like "1-9" meaning finished first out of 9 runners.
In this case all you have to do is put a simple formula in the len. cell somet like " if the number in the finished cell is 1 then the value in this cell is multiplied by -1"

Thanks again Iomaca, but the format of the cell which shows where the horse finished out of so many runners etc, is in "Date format" and I cant seem to get it to change to the format of what I want,

Paul

I don't know how you cut and paste your info, I just looked at the Unitab site and I saw the field as for instance "2-8' etc.

Show us your Excel sheet first.

I suggest you ask Shaun to look at your spreadsheet.
As I said I do not code in Excel (VBA) simply because it's not much used commercially.