Sort times.

[garyf]

Anyone know how to arrange the times,
In an excel spreadsheet so that races scheduled,
At say 11.00-12.0 come out first.

Example .

Say on one day I have this.

R1-11.35. (25.1/2014)
R2-12.25. (23/2/2015)
R4-12.50.(25/6/2014)
R5- 1.15.(2/5/2015.
R7-3.10..(8/3/2014)
R9 5.10.(16/12/2014)

Problem is when I C & P into my excel sheet (2010),
Exerts from a master sheet the 11.35 - 12.50 races come out last obviously,
Being a higher no's

I have gone to the A-Z function in formulas,
Mucked around there no luck.

I hope there isn't a formula or code you have to write,
Basic excel stuff sees me out.

I am gathering different races from different dates & years from a ,
Master data sheet then Copy & Pasting them into a brand new sheet.

Cheers.

[Shaun]

Are the race numbers in a separate cell to the race times and the race dates, if so convert the cell with race time to 24 hour time.

[garyf]

Are the race numbers in a separate cell to the race times and the race dates, if so convert the cell with race time to 24 hour time.

Yes they are leave it with me will have a shot at it tomorrow.

Thanks.

[garyf]

Yes they are leave it with me will have a shot at it tomorrow.

Thanks.
Just had a quick try.

When I click on numbers in the format cell over the time cell,
All I get is this as an option.

-1234.10 four times with a separator box unticked.

There is no other options.

Cheers.

[Shaun]

Select the column the times are in, right click-format cells-numbers-times, then select the last option 13:30:55

If that doesn't work it may require extra formating in the way of a formula to get what you want.

[jazzy]

If the data was HH:MM instead of HH.MM excel would automagically format the cell as time.

You'd still have to convert them to 24hr time to get it to sort correctly though

[Puntz]

Gary, was in the process of making the macro I use to make day lists,
but here's what it does.

If the race has already run, it leaves it out, till I fix the automated timer.

Let me know if the time format is right, it can be fixed, it's in the raw txt format from web scrape.

[garyf]

Thanks for the help everyone.

I will load more strategies tonight,
Have converted my EXCEL SHEET to,
The format Shaun suggested.

If that does not work tonight I will have a shot,
At what (Jazzy)(Puntz) suggested.

Surely one of these three suggestions will do it.

I feel like a (CLS-1) (ME) running in a (GROUP-1)(PUNTZ-JAZZY-SHAUN)
With this stuff.

Keep you posted.

Cheers.
Garyf.

[Shaun]

Any chance you can upload a sheet with an example so can see exactly how it looks.

[garyf]

Any chance you can upload a sheet with an example so can see exactly how it looks.

Appreciate the offer Shaun in a Restricted members forum,
No problems for the general population no hope, as there is,
All the data set out for all to see.

Will start the process in another 4-5 hours,
Have set it up to your recommendation will,
See what happens when I load from the Master sheet,
Into the new one, Jazzy may be right, will then check Puntz out.

If not no big deal I can grab someone from Freelancer for a,
Couple of hundred per hour should be done within an hour,
Can send the sheet off or do a team viewer if overseas.

Either way will do.

Cheers.
Garyf.

[Puntz]

garyf: Restricted members forum

yeah,