Viewing Thread:
"Excel help please"

I have set up a spread sheet and want Excel to compare lap times from Grant Turismo etc and give me a plus or minus figure.
I looked at format cells etc but can't figure it out, any help appreciated.

Ta

phi11ip I will email you an example of what I'm after, cheers

If life was that simple :), I want to include hundreth's of a second also, am I asking too much ?

You mean something to compaire your previous time to the next, and see which is faster/slower, like (- only to set layout):

--------A--------B----------C--------
1 --- LAP ---- TIME --- DIFFERENCE
2 --- 1 ------ 2.17 ------ N/A
3 --- 2 ------ 2.19 ------ + 0.02
4 --- 3 ------ 2.07 ------ - 0.12

If so, I think the formula is something simple like =(B2-B1)

OK...

You basically want to minus the original times from the new times...

If you've got them in cloumns then it's as easy as

=(B1-A1)

Then just click the cell and drag it down, it will automatically adjust the formula for each cell below...

If you have any problems, just email it to me, I'll do it in a few mins for you...

I'm in a helpful mood!

I have set up a spread sheet and want Excel to compare lap times from Grant Turismo etc and give me a plus or minus figure.
I looked at format cells etc but can't figure it out, any help appreciated.

Ta