cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Calculate difference between dates! Help!

Hello Guys, im having a really hard times now in PowerApps trying to calculate the difference between two dates to get the results in Hour.

I have been looking around for many hours trying to solve this but no success...

I have this Dates and Hours information

Liberação is the last

I need to do an = Liberação - Parada, and get the results in 00:00:00, in this case it would be about 03:00:00 hours..

I tried the DateDiff, but it resulted in -27, he considered 1 day and 3 hours...this is not what I want.

The formulas I need to use to bring the correct date is

Liberação Text Label = "Liberação "  & Text ( DateAdd(Liberação; TimeZoneOffset(Liberação);Minutes) ; "[\$-pt-BR]dd/mm/yyyy hh:mms" ; "pt-BR" )

I appreciated any helps!

3 REPLIES 3
Super User

## Re: Calculate difference between dates! Help!

Hi @Anonymous,

I recently went through the same exercise. You're correct, its not simple to diff dates and times in HH:MM format but it IS possible . Please see the thread here: https://powerusers.microsoft.com/t5/General-Discussion/Need-help-with-diffing-times-commented-code/m-p/136077#M47070.

@CarlosFigueira and I went through a lot of work to document how to do this.

Hope this helps!

Anonymous
Not applicable

## Re: Calculate difference between dates! Help!

Hi Erico, thanks for the reply.

It for sure gave me a north to this issue.

But Now I Im having another problem because of my form format.

On the create new form, i needed to adapt it because my users are using it on Desktop, so The Hour/Minute picker was terrible to choose, so i adapted it so they can write the hour/minte by theirselves.

This is not the problem, because i could adapt the formula you instructed me, to this scenario.

The actual problem is, on the edit screen, I needed to change the way they fill the dates, because I couldnt do the hour/minute shows on the excel file correctly.

So the problem starts now, when the form is edited, the formula loses the reference of the Hour/minute field, and calculates nothing, and do not update

Any idea how can I solve this?

Highlighted
Super User

## Re: Calculate difference between dates! Help!

Hm. I'm having trouble understanding the issue.

• I see you adjusted the Hour/Minute input fields from a Dropdown to a text box.
• You likely have to change all of the parts of the Hour / Minute Formulas from ".Selected.Value" to ".Text"

Hope this helps!

Announcements

#### Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

#### Power Platform World Tour

Coming to a city near you

#### PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

#### Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 440 members 4,738 guests
Recent signins: