2. PHPRunner General questions
  3. TOTAL of TIME-Field in list-page
This topic is locked

TOTAL of TIME-Field in list-page

 		6/28/2007 2:49:42 PM
PHPRunner General questions
Pfeiffer author

Hello Support,
I tried to get the list total of a field defined as TIME (f.e. 09:23:00)

The hours are summed, but not the minutes.
Any workaround to do this ?
Best regards
Uwe Pfeiffer
J
 		Jane 6/29/2007

Uwe,
thank you for pointing me to this bug.

We'll fix it in the next PHPRunner update.
D
 		darkmage0 7/27/2007

Hello
I was able to work around this by converting the time total column into seconds then devide by 3600 like this
time_to_sec(timediff(`startup time`,`shutdown time`)) / 3600 AS `TIME TOTAL`
OR
time_to_sec(`time total`) AS `TIME TOTAL`
I'm using mysql so hope this help's
Travis