View Full Version : Help with time difference in excel

Shaun

5th August 2012, 01:04 PM

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

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.46this link may help

http://office.microsoft.com/en-us/excel-help/calculate-the-difference-between-two-times-HP010070468.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

vBulletin v3.0.3, Copyright ©2000-2024, Jelsoft Enterprises Ltd.