How can I subtract time?

[Anonymous]

I would like to display in the text box the time subtracted the current time from the arrival time of the bus.

In excel, it can be displayed by finding the difference between two times but it is difficult to display with PowerApps.

Should I calculate using "TimeValue"?

I tried it, but I couldn't.

Does anyone know?

[lifelongjourney]

Hi riverhill,

Welcome to the PowerApps Community! I'll explain the method I took to create your situation:

Controls:

• tbxBusArrive - Text input control for changing the time the bus arrives
• btnMyFunctions - Button for running much of our important logic
• timTimer - Timer that shows the countdown clock

btnMyFunctions OnSelect method:

UpdateContext({varTimeBusArrive: Text(TimeValue(tbxBusArrive.Text), "[$-en-us]hh:mm:ss"), varTimeNow: Text(Now(), "[$-en-us]hh:mm:ss")});

UpdateContext({varTimerDuration: TimeValue(varTimeBusArrive) - TimeValue(varTimeNow)});

Note: you must separate the UpdateContext statements so the context variable changes can be fully processed so they are properly set for the next statement.

timTimer properties:

Duration: varTimerDuration

Text: Text(Time(0,0,0,varTimerDuration - Timer1.Value), "[$-en-us]hh:mm:ss")

The only part I haven't tackled is clearing the Timer1 Value, I haven't figured out how to do this yet, but you may not have to do this for your app.

Hope this helps! Let me know if anything needs clarifying.

[v-yamao-msft]

Hi Riverhill,

Here is an article about “Show text and format dates and times in Microsoft PowerApps”, in this article, the section about “Calculate times based on hours, minutes, and seconds” could be a reference for you.

The link of the article is:
https://powerapps.microsoft.com/en-us/tutorials/show-text-dates-times/

Best regards,
Mabel Mao

[Anonymous]

Thank you.I will try it!

[Ryanmch]

To subtract time, you will need to calculate the amount of time to subtract in days then subtract that from the date/time value.

Example:

(DateTimeValue("1/13/2017 3:35 PM") - 5/60/24) - This will subtract 5 min from the date/time value (5 (min) divided by 60 (minutes per hour) divided by 24 (hours per day))

To get the difference of 2 date/time values in minutes, simply reverse the process:

(DateTimeValue("1/13/2017 3:35 PM") - DateTimeValue("1/13/2017 3:32:30 PM"))*24*60 - multiply by 24 (hours per day) and 60 (minutes per hour)

Ryan McHenry [MSFT - PowerApps]