12-19-2019 11:55 AM
Have you ever needed to track how long it's taking to complete a process in your Power App? Using the Timer Control you can do that, however, the output of that timer value is stored in an unfriendly format. In this video, I show how you can take that timer value and format it in hours, minutes and seconds format.
Here's the formula to output the timer control into this format:
With( { seconds: RoundUp(Timer1.Value/1000,1) }, With( { minutes: RoundDown(seconds / 60,0), secondsRemaining: Mod( seconds, 60 ) }, With( {hours: RoundDown(minutes / 60,0)}, hours & " hour(s) " & minutes & " minute(s) " & secondsRemaining & " second(s)" ) ) )
watch?v=dDjOVwR1AXc