OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)

- Horse Race Betting Systems (http://forums.ozmium.com.au/forumdisplay.php?f=10)

- - Excel Help (http://forums.ozmium.com.au/showthread.php?t=14295)

Benny

12th August 2006 03:41 PM

Excel Help

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

jfc	13th August 2006 07:52 AM

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.

Wunfluova

13th August 2006 10:16 AM

Curious that you didn't suggest reversing the times component to avoid finishing up with a negative answer?

Benny

13th August 2006 11:46 AM

thanks guys.

benny

jfc	13th August 2006 12:41 PM

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

Try:

=("1:42.45"-"1:38.06")/0.066

You may need to change the cell format.

I don't know what you're trying to do.

Get ~16 times ~4.4 Seconds?

----

Nor do I understand Wunflova's point.

All times are GMT +10. The time now is 02:09 AM.