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

I'll take your word for it, way above my head now. Cheers

Oops, sorry, that second formula should read as follows :

=IF(K23
My bad

;-)

Sorted, just came up with this formula which puts the plus times into different columns.

=IF(K5>M5,SUM(K5-M5),0)

and

=IF(K5
which puts the faster time in the other column.

If you want to see the spreadsheet just say yes and I'll email it to you.

:D

Sussed it, you have to do a custom format of the cells and select the mm.ss.0 and then edit the formula you want to mm.ss.00 and this then works.

But before it will work you also need to get rid of the date in the cell formula. For some strange reason, if you put a 1 in the cell you've just formatted it will appear like this.

01/01/1900 00:00:00

WTF Microsoft are doing here is beyond me, anyway you have to manually edit the cell and also put an extra .00 at the end.

Still working on the minus calculation problem, methinks an IF statement may come in handy.

Select the cells...

Format cells> Time> 00:00.00

Or the other one that looks like it!

can you let me know the formula/cell settings you used to get the positive times OK.

Cheers

Hmmmmmmm...

Excell doesn't seem to want to do minus times...

I can get the difference when a time has a positive difference, but when there's a negative difference, it just won't work!

I haven't got a clue here...

Tried formatting the cells but it doesn't have anything...

Cool, I just got an email...

Wonder who it's from....

I got your address from your site (knew it would come in handy one day!)

Argentina Capilla del Monte R 3.54.32 3.44.37

I simply want to take time 2 away from time 1.

Thanks

Somebody needs an email address!

[email protected]

Zip it though, I don't know if Outlook likes Excel files...