PDA

View Full Version : Help with time difference in excel


Shaun
5th August 2012, 12: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, 12: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, 06: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, 06: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, 08: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