13th August 2006, 07:52 AM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by Benny
I using the following formula to compare times, but there is an error. Can someone please help?
=(1:38.06-1:42.45)/0.066)
benny
|
Excel doesn't understand expressions like:
1:38.06
You have to convert it yourself to
98.06
Also your ( & ) are unbalanced.
Curious that this could have stumped 15 viewers. |