Time Difference

(1) Share

Report

Posted on by neill_long

728

I am trying to calculate the time difference. I have the following formula on a label:

DateDiff(DateTimeValue(ThisItem.StartTime),DateTimeValue(ThisItem.EndTime),Hours)

But it only shows the number of hours and not the minutes. For example, I have a start time and end time, if start time is 08:00 and end time is 12:30, the label displays 4.

How can i get it to show 4 hours 30 mins (4.5)

The labels are in a gallery which is connected to a collection.

thanks

Categories:

Building Power Apps

All responses (4)

Answers (2)

Sort by

Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@neill_long

Convert Minutes to either "X Hours Y Minutes" or "X.Y hours"

For example, to convert it to "X Hours Y Minutes"

With ( {st:DateTimeValue(ThisItem.StartTime),et:DateTimeValue(ThisItem.EndTime)} ,DateDiff(st,et,Hours) & " hours " & Mod(DateDiff(st,et,Minutes),60) & " mins" )

and to convert it to "X.5 hours"

With ( {st:DateTimeValue(ThisItem.StartTime),et:DateTimeValue(ThisItem.EndTime)} ,Text(DateDiff(st,et,Minutes)/60 ,"#.#") )

and for both at the same time:
With ( {st:DateTimeValue(ThisItem.StartTime),et:DateTimeValue(ThisItem.EndTime)} ,With ( {dh:DateDiff(st,et,Hours),dm:DateDiff(st,et,Minutes)} ,dh & " hours " & Mod(dm,60) & " mins" & " (" & Text(dm,"#.#") & ")" ) )

Check if it helps @neill_long
SphesihleSibiya 81 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @neill_long,

Try This:
The Mod operation should give you the remainder in minutes since there is 60 minutes in an hour
DateDiff(DateTimeValue(ThisItem.StartTime),DateTimeValue(ThisItem.EndTime),Hours) & " hours " & Mod(DateDiff(DateTimeValue(ThisItem.StartTime),DateTimeValue(ThisItem.EndTime),Minutes),60) & " Minutes"
Verified answer

victorcp 2,350 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Hi,
you have to get the difference in minutes instead of hours, and then do the necessary calculations.

Here are two examples to achieve what you want:
RoundDown(DateDiff(Today(),Now(),Minutes)/60,2)

With({time:DateDiff(Today(),Now(),Minutes)}, RoundDown(time/60,0) & " hours "& Mod(time,60)) & " min"
With function is used to create a variable (time) that works inside its scope.

Hope it helps 🙂
neill_long 728 on at

Like
a
(2)

Report
Copy link

Link copied!
thanks everyone for your help, all great suggestions. Went with:

RoundDown(DateDiff(ThisItem.StartTime,ThisItem.EndTime,Minutes)/60,2)

Works great.