Unanswered

Displaying date difference in both hours and minutes

(0) Share

Report

Posted on by Community Power Pla...

I have two dates, declared as StartDate and EndDate. I can display the difference between each date in either hours or minutes, but I can not figure out how to display both hours and the remaining minutes.

For example, f the StartDate is the 1st April 2019 at 1:00 am and EndDate is the 2nd of April 2019 at 1:30 am, I want it to calculate the difference as 24 hours and 30 mins rather than rounding to the nearest hour with the DateDiff function.

This is the formula in use: DateDiff(txtStartDate.SelectedDate, txtEndDate.SelectedDate, Hours)

Any help would be appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Verified answer

CarlosFigueira on at

Like (3)

Report
You can use the DateDiff function twice, one for the hours and one for the minutes, and take the value of the minutes modulus 60 (to get only the minutes part), like in the expression below (where I get the start/end times from a date picker and two dropdown controls):

DateDiff( dtStart.SelectedDate + Time(Value(ddHourStart.Selected.Value), Value(ddMinuteStart.Selected.Value), 0), dtEnd.SelectedDate + Time(Value(ddHourEnd.Selected.Value), Value(ddMinuteEnd.Selected.Value), 0), Hours) & ":" & Mod( DateDiff( dtStart.SelectedDate + Time(Value(ddHourStart.Selected.Value), Value(ddMinuteStart.Selected.Value), 0), dtEnd.SelectedDate + Time(Value(ddHourEnd.Selected.Value), Value(ddMinuteEnd.Selected.Value), 0), Minutes), 60)

The attached app shows this formula in action. To open it, save it locally, then go to https://create.powerapps.com, select Open, Browse, and find the file that you saved before.

Hope this helps!

ForumThread278958...

Was this reply helpful? Yes No
SoPatt Microsoft Employee on at

Like (0)

Report
The Mod function gives you the remainder after integer division.

So I think an expression that gives you what you want would be:
RoundDown( DateDiff( txtStartDate.SelectedDate, txtEndDate.SelectedDate, Minutes )/60 ) & " hours and " & Mod( DateDiff( txtStartDate.SelectedDate, txtEndDate.SelectedDate, Hours ),60 ) & "minutes"

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you very much, this was what I was looking for!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Carlos.

This formula has been working for me until today. The first DateDiff has invalid arguments and the error reads "The DateDIff function has some invalid arguments." and the end of the first formula where Hours is, an error message reads "Invalid arguments type (Number). Expecting a Text value instead."

The other DateDIff formula works fine but for some reason, Hours is not working. Minutes, Days and Years works fine.

Any idea as to why this is?

Thanks!

Was this reply helpful? Yes No
Pierrot-56 18 on at

Like (0)

Report

Hello Carlos, it doesn't seem to be working.
the difference between hours:minutes is not calculated when there are minutes; the formula adds an hour in my case; please let me know how to correct this.

HoursMinutes).png

Was this reply helpful? Yes No
CarlosFigueira on at

Like (0)

Report

@Pierrot-56 what is the expression that you are currently using?

Was this reply helpful? Yes No
Pierrot-56 18 on at

Like (0)

Report
@CarlosFigueira Thanks for the reply
The formula is that of the example that you were kind enough to provide

DateDiff( dtStart.SelectedDate + Time(Value(ddHourStart.SelectedText.Value); Value(ddMinuteStart.SelectedText.Value); 0); dtEnd.SelectedDate + Time(Value(ddHourEnd.SelectedText.Value); Value(ddMinuteEnd.SelectedText.Value); 0); Hours) & ":" & Mod( DateDiff( dtStart.SelectedDate + Time(Value(ddHourStart.SelectedText.Value); Value(ddMinuteStart.SelectedText.Value); 0); dtEnd.SelectedDate + Time(Value(ddHourEnd.SelectedText.Value); Value(ddMinuteEnd.SelectedText.Value); 0); Minutes); 60)

Was this reply helpful? Yes No
CarlosFigueira on at

Like (1)

Report
It seems like DateDiff for the hours is operating on the hours directly (9 to 13) or rounding it up, instead of the time difference (3:15). You can fix that by calculating the difference in minutes, and rounding down to the nearest 60, with the expression below:

RoundDown(DateDiff( dtStart.SelectedDate + Time(Value(ddHourStart.SelectedText.Value); Value(ddMinuteStart.SelectedText.Value); 0); dtEnd.SelectedDate + Time(Value(ddHourEnd.SelectedText.Value); Value(ddMinuteEnd.SelectedText.Value); 0); Minutes) / 60; 0) & ":" & Mod( DateDiff( dtStart.SelectedDate + Time(Value(ddHourStart.SelectedText.Value); Value(ddMinuteStart.SelectedText.Value); 0); dtEnd.SelectedDate + Time(Value(ddHourEnd.SelectedText.Value); Value(ddMinuteEnd.SelectedText.Value); 0); Minutes); 60)

Another option to make this expression above a little more readable is to use the With function (which was introduced after I first replied to this post):

With({ startTime: dtStart.SelectedDate + Time(Value(ddHourStart.SelectedText.Value); Value(ddMinuteStart.SelectedText.Value); 0); endTime: dtEnd.SelectedDate + Time(Value(ddHourEnd.SelectedText.Value); Value(ddMinuteEnd.SelectedText.Value); 0) }; With({ diffMinutes: DateDiff(startTime; endTime; Minutes) }; RoundDown(diffMinutes / 60; 0) & ":" & Mod(diffMinutes; 45)))

Hope this helps!

Was this reply helpful? Yes No
Pierrot-56 18 on at

Like (0)

Report

Thanks for your time on this, it's working well now.

Was this reply helpful? Yes No
spollins 2 on at

Like (0)

Report

Solution is not quite right in the first condition of the DateDiff if you are checking for hours this solution works well if the hours worked independent of minutes. For example 2:15 to 4:00 would show 2hrs which is incorrect an if state on minutes needs to be added to hours logic if the end minutes are less than start subtract an hour

Was this reply helpful? Yes No