OZmium Sports Betting and Horse Racing Forums - Help with time difference in excel

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

- General Topics (http://forums.ozmium.com.au/forumdisplay.php?f=59)

- - Help with time difference in excel (http://forums.ozmium.com.au/showthread.php?t=24727)

Shaun

5th August 2012 01:04 PM

Help with time difference in excel

I am stuck and Google is not my friend at the moment.

I have 2 times in excel a current time and the race time, i meed to find the difference between them.

I have tried a few different formulas like.
=DK6 - DK5 + (DK5 < DK6)

But i am getting a difference of 22 hours

i know it has something to do the format of the time or such.

Here are the time

Race time 12:35:00pm
Current time 11:02:52am

Here are the times as numbers.
0.52
41126.46

lomaca

5th August 2012 01:29 PM

Quote:

Originally Posted by Shaun

this link may help
http://office.microsoft.com/en-us/e...P010070468.aspx
I haven't tried but. don't use excel!
Cheers

Dennis G

5th August 2012 07:39 PM

Shaun,
I just put in those times (formatted to 13:30:30) subtracted the former from the latter and got - 1:32:08 which would appear to be the desired result.

And I tried it with data scraped from TattsBet for a correct result, so I can't help lest to say it's in the formatting..

Shaun

5th August 2012 07:51 PM

I worked out that the time i was using was formatted with a date of 0/01/1900 this is what was causing the problem, i formatted my other time the same to solve the problem just hoping it works out ok.

Pete the punter

23rd August 2012 09:57 PM

you can run a formula to work out the race time from the computer system time by using "race time - Now()" everytime you refresh the sheet the difference in time will change, hope this may help you

Pete

All times are GMT +10. The time now is 08:48 AM.