Thread: Sort times.
View Single Post
  #1  
Old 27th July 2015, 12:21 AM
garyf garyf is offline
Banned
 
Join Date: Oct 2011
Posts: 366
Question Sort times.

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.
Reply With Quote