Column sum on time element gives blank page

[tmntmn]

Hi All

I've run into a problem with column sum on Plug-in element time

The format recorded in database is 00:00:00 alias hours,minutes seconds

However if I choose "Sum the total column = Yes" in list view settings the result is a blank page.

Can anyone confirm this or have a workaround?

Best regards

Thomas

Latest github from today

PHP Built On Linux server2722 2.6.18-238.5.1.el5xen #1 SMP Fri Apr 1 19:35:13 EDT 2011 x86_64
Database Version 5.5.37-log
Database Collation utf8_general_ci
PHP Version 5.5.17
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.4.1 Stable [ Ember ] 21-March-2015 20:30 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

 

[tmntmn]

Hi again

I've made a workaround using the Custom Calc.

In "Custom Query" using "SEC_TO_TIME( SUM( TIME_TO_SEC( %s) ) )" gives the correct result.

For anyone with the same problem.

Best regards

Thomas