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 app
this formula should be only 00:00:05
Solved! Go to Solution.
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.
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.
Your recommendation helped me a lot!!