Hi
I have 3 stopwatches for a competition done with variables. The format is displayed as label output 00:00,0 (min,sec,decsec).
Each competitor has a buzzer button which they hit when completed their task. The timer stops and the times are stored in a listview, example 00:43,6
So far no problem.
For the next round i want to add the times from the first round when they finsihed their second task; example 00:43,6 + 00:23,3 = 01:06,9
This should happen as soon as they hit the button. I have use excel to export times in this format and excel can add them togheter for me. The problem i have is i cant export to excel until all timers has stopped, if i do it with the button being pressed it stops the other timers running for some seconds. Storing to excel interupts the script timer used to generate the stopwatches. So im looking for other ways within the widget to add the total time instead of using excel but stll have the format of 00:00,0
I can convert the time into just a variable integer 00:43,6 -> 436 and so on and sum those values in a listview for instance. But i cant figure out how to get it back to the "time" format 00:00,0. Or if there is other options i havent thought of adding times in this format in the widget
Second is it possible to sort columns in a listview so they stick togheter? i want a top four list with each country and time. So i need the times to be sorted in the fastest but also keep track of what country it beongs to.
COUNTRY_A - 00:30,5
COUNTRY_B - 00:23,4
COUNTRY_C - 00:45,7
COUNTRY_D - 00:22,1
---------------------------sorted->
COUNTRY_D - 00:22,1
COUNTRY_B - 00:23,4
COUNTRY_A - 00:30,5
COUNTRY_C - 00:45,7
Appreciate any help or feddback for this.
Best
//Rob