Error code Difference date and time.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Good afternoon;

I'm trying to get the difference between two dates and two starting and ending hours, but it works correctly until minute "29". After the code adds 1 hour. I'm in Brazil / São Paulo.

With(
 {
 _TotalMinutes: DateDiff(
 ('DATA INICIAL'.SelectedDate + Time(
 Value('HORA INICIAL'.Selected.Value);
 Value('MINUTO INICIAL'.Selected.Value);
 0
 ));
 ('DATA FINAL'.SelectedDate + Time(
 Value('HORA FINAL'.Selected.Value);
 Value('MINUTO FINAL'.Selected.Value);
 0
 ));
 Minutes
 )
 };
 Round(
 _TotalMinutes / 12 / 60;
 0
 ) & " Days " & If(
 Round(
 _TotalMinutes / 24 / 60;
 0
 ) <= 0;
 Round(
 _TotalMinutes / 60;
 0
 );
 Mod(
 _TotalMinutes;
 24
 )
 ) & " Hours " & Mod(
 _TotalMinutes;
 60
 ) & " Minutes"
)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 156,277 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Try RoundDown() instead of Round()

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No