I keep track of my live poker sessions in excel and one of the stats I have is the moving average for the last 50 sessions played at a particular game/limit (1/2 NL for example) so I can see if my play seems to be improving over time. When I first started playing I was playing 1/2 NL exclusively and playing long sessions. Now I've moved up and most of my 1/2 NL sessions are very short ones where I was essentially waiting for a seat at the game I really wanted to play. Needless to say the number of hours played in my first 50 sessions and my last 50 sessions are totally different and the graph is hard to interpret for that reason.
So my question is: Is there a way to average say the last 100 hours played instead of say the last 50 seasons? I already have a row with cumulative hours played but I'm not sure what formula (if any) would be able to do this.
I think you're misunderstanding my question. I'm not asking how to get the last 100 sessions but how to get the last 100 hours. The sessions aren't the same length. My old ones tend to be long and my recent ones tend to be short. Not sure if it can be done without writing a VBA macro.