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!
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications