SUM TIMER

[ALFRED05]

Hi everyone,

I am having issues adding timer "times"...I have a sharepoint list where I collect time passed from a timer in the APP..

Then I sum all the times for an specific ID, BUT when making the sum it adds 5 HOURS...I guess it is someting about the timezone...how can I workaround this?

here are some images.

time collected from TIMERS in the appthis formula should be only 00:00:05

[Eelman · Accepted solution]

@ALFRED05 

Timer controls use milliseconds and if I was doing this I would store my timer data as a Number data type, you appear to be using a Date/Time (Time) data type. What I suspect is happening is that your data is getting stored as Date/Time

eg 3 seconds from your timer is stored as 12:00:03 AM ie 3 seconds past Midnight

.. and not as a Number ie 3000 milliseconds.

Once your data is stored correctly you can then do the conversion back inside PowerApps to make it look like hh:mm:ss as needed.

[ALFRED05]

Your recommendation helped me a lot!!