time played in HH:MM:SS

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

time played in HH:MM:SS

Postby kikpo » Tue Mar 13, 2012 6:18 pm

How to create?
kikpo
 
Posts: 12
Joined: Fri Dec 19, 2008 2:42 pm

Re: time played in HH:MM:SS

Postby WhiteRider » Wed Mar 14, 2012 4:19 am

You can't get the time in seconds, but there is an HH:MM stat available for free download from the Customize PokerTracker called "Session time H:MM" (cash or tournament), posted by me.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: time played in HH:MM:SS

Postby kikpo » Wed Mar 14, 2012 6:13 am

I know about "session time H:MM", but I play heads up sng hyper turbo where a lot of matches are finished in less than 1 minute (sometimes in few seconds), but PT3 show it as 1 minute. How it is in PT4?
kikpo
 
Posts: 12
Joined: Fri Dec 19, 2008 2:42 pm

Re: time played in HH:MM:SS

Postby kraada » Wed Mar 14, 2012 8:42 am

There is no "Sessions" section of stats in PT4 - the only collection of hands is in the Player section - which, since it is broken down into hands directly should mean you can get resolutions of less than a minute - but I have not tested this personally. Also: If you had a one hand tournament, how much time would you say that it took?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: time played in HH:MM:SS

Postby kikpo » Wed Mar 14, 2012 12:23 pm

Yeah, I see "Start Time" and "End Time" are based on date when hand was started. So in one hand tournament, stats "start time" and "end time" show the same hh:mm:ss. That would look like, the tourney was played in 0 seconds, even if the hand was played in 10 sec or more.
kikpo
 
Posts: 12
Joined: Fri Dec 19, 2008 2:42 pm

Re: time played in HH:MM:SS

Postby kraada » Wed Mar 14, 2012 12:43 pm

Right but we have no other data for that tournament beyond the one hand. If we have two hands we have the time between the two hands to use to calculate. With just one hand we have only the one data point though which complicates things.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: time played in HH:MM:SS

Postby kikpo » Sat Mar 17, 2012 3:29 pm

I changed the column cnt_minutes expression (section: HoldemTournament Tournament) from

date_subtract_min[tourney_holdem_results.date_end,tourney_holdem_results.date_start]+1

to

date_subtract_sec[tourney_holdem_results.date_end,tourney_holdem_results.date_start]/60

and I used it to make custom stat to show tourney duration. The new stat shows more accurate time in minutes (like 3.2 min).

However, in a tournament with two hands, time is counted from the beginning of the first hand to the beginning of the second hand, losing the duration of last hand. The same with one hand tournament, where duration would be 0.
So we need add average length of the one hand to the column expression:

(date_subtract_sec[tourney_holdem_results.date_end,tourney_holdem_results.date_start]/60) + "average length of hand"

Obviously length of the hand should be in minutes with decimals: 15 sec will be 0.25, 1 min 06 sec will be 1.1 etc.

I recommend use it for players play very short tourneys.
kikpo
 
Posts: 12
Joined: Fri Dec 19, 2008 2:42 pm


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 13 guests

cron
highfalutin