Group of "no time difference"

komhs
NewLounger
Posts: 8
Joined: 05 Jul 2016, 23:36

Group of "no time difference"

Post by komhs »

Hi to all and thank you in advance for any positive or negative reply.

I am trying to connect two logics in an excel sheet and i can't. It has to do with time difference and if i have a profit or a loss.

I have included all the necessary informations in the attachment file.

Thanks again in advance
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78671
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Group of "no time difference"

Post by HansV »

I'm afraid I cannot help you with this one.
Best wishes,
Hans

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Group of "no time difference"

Post by Rudi »

I too am lost in the details of this query.

I think perhaps LisaGreen would be the best person to assist you based on the topic in question.
Hopefully she will log in soon again...
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

komhs
NewLounger
Posts: 8
Joined: 05 Jul 2016, 23:36

Re: Group of "no time difference"

Post by komhs »

I know that it is difficult, but seriously, thank you so much for trying to help me. Two days i am trying to find a solutions, but...

komhs
NewLounger
Posts: 8
Joined: 05 Jul 2016, 23:36

Re: Group of "no time difference"

Post by komhs »

I have tried to made it easier and to write how the formula should be.

Make another try with this one please
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78671
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Group of "no time difference"

Post by HansV »

Does the auxiliary column W help? Perhaps you could use it instead of column L in the formulas.

If not, ignore my suggestion.
koskok1.xls
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

komhs
NewLounger
Posts: 8
Joined: 05 Jul 2016, 23:36

Re: Group of "no time difference"

Post by komhs »

Yes, i can do that Hans, but my main issue is that i can't make my system to understand what stake it must use if there is not two hours difference between the games (yellow). And the solution is to use the equation that the game after the last known result used.