Recent content by NWildblood

Thanks Dave, that is great.

Thanks zelgar, I will take a look at that tomorrow.

Skip, I can take a bollocking, I have been doing this project among a load of other things, and under pressure of having very little time to turn this bit around (I did not choose the launch date, someone on a much higher pay grade did that). I have legions of track engineers out there to whom...

Sheer incompetence Skip, as you have kindly established. Cheers.

Thanks @zelgar

@Skipvaught, are you asking me what the object of this exercise is, or just launching a personal attack ?

@skipvaught "It would have been helpful to state that your input cells (columns A & B) were expressed as M.YYYY. You seemed to imply that you simply wanted the RESULT to be expressed as M.YYYY and the inputs were MILES. " I had said "Put simply, I need to determine the difference in Miles and...

Well - a great thanks to all of you, and apologies for taking up your time. For clarification I currently work in the UK rail industry where data sets for assets going back a century in age are unfortunately recorded and reported in terms of miles and yards; perhaps I should have clarified this...

This works fine PHV. Thank you ! No hay nada como un buitre cabr=n como un ojo de cristal.

OK, here are some results: @SkipVought A1 - B1 = C1 25.1727 - 24.0880 = 1.0847 EXPECTED RESULT However, using A1-B1 I was getting 1.0149 But using =(D2MY(D1-E1)/1760)conversion to yards *1760 - I was able to get 1.0847 from D1) 44303.952 - E1) 42394.88 In a second example, A2...

@Skipvought; I spoke too soon, got some mixed results, will post how tomorrow. (Am not in the office today). Thanks again No hay nada como un buitre cabr=n como un ojo de cristal.

All, this has been extremely helpful and is much appreciated; I am now getting the results I wanted, can't thank you enough. No hay nada como un buitre cabr=n como un ojo de cristal.

Thanks Peter - that's exactly where I got my example from - however I can't seem to make the converstion to Miles.Yards No hay nada como un buitre cabr=n como un ojo de cristal.

Thank you zelgar, that is helpful - although I am struggling to apply this to show the result: CELL A1 - CELL B1 = CELL C1 25.1727 24.0880 1.0847 (I seem to be getting 0.0001) Thanks again OOS No hay nada como un buitre cabr=n como un ojo de cristal.

Hi, any help gratefully received: I am working in imperial (Miles/Yards) and have found that it is not possible create a custom number format that will deal with imperial linear distances: yards and miles. Put simply, I need to determine the difference in Miles and Yards between e.g. Mileage...