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
Parada is the first
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
Parada Text Label = "Parada " & Text ( DateAdd(Parada; TimeZoneOffset(Parada);Minutes) ; "[$-pt-BR]dd/mm/yyyy hh:mm:Ss" ; "pt-BR" )
Liberação Text Label = "Liberação " & Text ( DateAdd(Liberação; TimeZoneOffset(Liberação);Minutes) ; "[$-pt-BR]dd/mm/yyyy hh:mm:Ss" ; "pt-BR" )
I appreciated any helps!
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!
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?
Hm. I'm having trouble understanding the issue.
Hope this helps!
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand