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
Group of "no time difference"
-
- NewLounger
- Posts: 8
- Joined: 05 Jul 2016, 23:36
Group of "no time difference"
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Group of "no time difference"
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...
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- NewLounger
- Posts: 8
- Joined: 05 Jul 2016, 23:36
Re: Group of "no time difference"
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...
-
- NewLounger
- Posts: 8
- Joined: 05 Jul 2016, 23:36
Re: Group of "no time difference"
I have tried to made it easier and to write how the formula should be.
Make another try with this one please
Make another try with this one please
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Group of "no time difference"
Does the auxiliary column W help? Perhaps you could use it instead of column L in the formulas.
If not, ignore my suggestion.
If not, ignore my suggestion.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 8
- Joined: 05 Jul 2016, 23:36
Re: Group of "no time difference"
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.