it's me again. I've tried a lot of things I found searching the net but nothing is working. I have a Sharepoint list titled "Condensed SA Request info" with two columns that have date and time, timestamps written when a record is created (timestamp submitted) and one that timestamps when the record has been accepted (Lead CSA Accept). Both are configured as date/time in the Sharepoint list. I have another column titled "response time" that calculates the difference in the other two Columbus to establish the amount of time it took from submit to accept. That field is a calculated field with the following formula and it's set as date/time: =TEXT([Lead CSA Accept]-[Timestamp submitted],"h:mm")
I'm trying to get a text label (or any visible item) in power apps to average the response time column and dynamically show the current wait time. I've tried a TON of stuff but can't seem to get it to work. I'm leaning towards the : in the h:mm format causing the issues I've been seeing. Any thoughts?
