Unanswered

Live 'Elapsed Time Since Last Update' Field

(1) Share

Report

Posted on by JWPowder

213

Hello, I am trying to create a field that will look at the given date/time in an adjacent field and update in real time with the time that has elapsed since that update.

For this example, the time the field was last updated is "Label2_3". I would like the live updating elapsed time to be in "Label2_5".

I'm assuming that I will need to use some sort of timer but not sure how to configure it to do this.

Any help is greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (2)

Report

@JWPowder

Yes, a Timer!

Place a Timer control in your app and set the duration to 1000. Set the Repeat to be on and the Pause off and the AutoStart on.

In the OnTimerEnd action, set the following formula: Set(glbTime, Now())

You will now have a variable in your app that you can use to determine real time.

So, in your label, you can do a DataDiff function to get the elapsed duration.

Ex. Abs(DataDiff(DateTimeValue(Label2_3.Text), glbTime, Seconds))

This will show the elapsed seconds.

I hope this is helpful for you.

Was this reply helpful? Yes No
JWPowder 213 on at

Like (1)

Report

Hello @RandyHayes, this worked with one slight modification. You typed DataDiff when I think you meant DateDiff.

This was the formula I used to return the time in a "XX Hours, XX Minutes" format:
With({_minutes: Abs(DateDiff(DateTimeValue(Label2_29.Text), glbTime, Minutes))},
RoundDown(_minutes/60, 0) & " Hours, " & Text(Mod(_minutes, 60), "") & " Minutes"
)

Thank you for your help!

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@JWPowder

Ooops yes...DateDiff is what I meant. Glad that worked for you.

Was this reply helpful? Yes No