![Old](images/statusicon/post_old.gif)
27th July 2015, 12:21 AM
|
Banned
|
|
Join Date: Oct 2011
Posts: 366
|
|
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.
|