totalize numeric minutes and represent in hh:mm

Scriptcase 8 Discussion
#1

Hello to all.
I have that need and do not know how to solve it with scriptcase.
I have a table with a numeric field that is the ‘minutes’.
In a grid I list the records and do the total.
I have to see in the list that in total represent ‘hourly’ field hh: mm


Example :
           minutsON minutsOFF   %ON  %OFF
Record 1:    30       50
Record 2:    40       80
            ---      ---  ---- ---    ---
Total:       70      130 (=200) 35%   65%
And this far ok.

I have to represent the list as well:
           minutsON minutsOFF        %ON  %OFF
record 1:    00:30    00:50
Record 2:    00:40    00:80
             -----    -----  -----   ---   ---
Total:       01:10    02:10 (=03:20) 35%   65%

I have the necessary functions for conversions minutes->hh:mm and vice versa, but scriptcase not let me totalize a numeric field and represent it otherwise! It must belong to (appear) to the list!
Am I right?
If so, how can you solve?
I do not think there are events in the ‘totals’ section for the chance to elaborate
Hello and thanks
Enrico

#2

Solved.
I had not seen carefully the relevant help page: http://www.scriptcase.net/docs/en_us/v81/manual_mp.htm#grid-applications/grid/group-by/events

Hello and thanks
Enrico

#3

Have you thought about doing the conversion from mins to time in the select using sometime like:

<a href="http://localhost/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fselect.html&server=0&token=5c06de5e48410a847c0ad6f4cea6e118">SELECT</a> sec_TO_TIME(121*60)

replace the 121 with the field in mins you are selecting