Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
Reload this Page Help with time difference in excel
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 5th August 2012, 12:04 PM
Shaun Shaun is offline
Member
  
Join Date: Jan 1970
Location: Western Australia
Posts: 3,457
Default 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
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________
Reply With Quote
  #2  
Old 5th August 2012, 12:29 PM
lomaca lomaca is offline
Member
  
Join Date: Jan 1970
Posts: 1,096
Default
Quote:
Originally Posted by Shaun
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
this link may help
http://office.microsoft.com/en-us/e...P010070468.aspx
I haven't tried but. don't use excel!
Cheers
Reply With Quote
  #3  
Old 5th August 2012, 06:39 PM
Dennis G Dennis G is offline
Member
  
Join Date: Mar 2006
Posts: 112
Default
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..
Reply With Quote
  #4  
Old 5th August 2012, 06:51 PM
Shaun Shaun is offline
Member
  
Join Date: Jan 1970
Location: Western Australia
Posts: 3,457
Default
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.
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________
Reply With Quote
  #5  
Old 23rd August 2012, 08:57 PM
Pete the punter Pete the punter is offline
Member
  
Join Date: May 2011
Posts: 45
Default
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
Reply With Quote
Reply

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 11:03 AM.

Contact Us - OZmium Pty Ltd - Archive - Terms of Use - Privacy Statement - Top

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655