How to get time difference between two start time and end time.

(0) Share

Report

Posted on by Suchithra_A

Hi, I have four drop downs , which stores hours and minutes of start and end.

which is as shown below FIRST and LAST fields.

Now I want to calculate difference between hours and minutes.

I have used below formula on default property of text field (No of hours) to calculate number hours.

Text(((HourValue2.Selected.Value*60+MinuteValue2.Selected.Value)-( HourValue1.Selected.Value*60+MinuteValue1.Selected.Value))/60,"[$-en-US]###.00")

where hours is calculating properly. But minutes is not calculating exactly.

Kindly help me to exact time difference.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

mdevaney 29,989 Moderator on at

Like (0)

Report
@Suchithra_A
You can use the DATEDIFF function to accomplish this goal without complicated calculations

DateDiff( Time(HourValue2.Selected.Value, MinuteValue2.Selected.Value,0) Time(HourValue1.Selected.Value, MinuteValue1.Selected.Value,0), Hours )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Suchithra_A 88 on at

Like (0)

Report

@mdevaney

This is not working for me.Facing Below error.

"Invalid argument type(Text). Expecting Number Value instead."

I tried the formula
Value(DateDiff(
Time(Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value),0)
Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value),0),
Hours))
This is also not working.
Please help me to fix this.

Was this reply helpful? Yes No
Suchithra_A 88 on at

Like (1)

Report

Hi,
I have modified the formula to
Value(DateDiff((DateValue2_2.SelectedDate + Time(Value(HourValue2_2.Selected.Value), Value(MinuteValue2_2.Selected.Value), 0)),
(DateValue1_2.SelectedDate + Time(Value(HourValue1_2.Selected.Value), Value(MinuteValue1_2.Selected.Value), 0)),Hours))

Here time is calculating only in terms of number hours.
I want in both hours and minutes .
Example :
I want No: of hours as "2:30".

Anyone please guide me.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report
@Suchithra_A
Please try this code. If you are getting an error please share the error message.

DateDiff( Time(Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value,0)) Value(Time(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value,0)), Hours )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Suchithra_A 88 on at

Like (0)

Report

@mdevaney
Still getting error:
"we expect text at this point of formula"

Was this reply helpful? Yes No
Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report
@Suchithra_A

You are getting an error because you did not specify the date format in the 2nd argument of the TEXT function.

Text( DateDiff( Time(Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value,0)) Value(Time(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value,0)), Hours ), ShortDateTime )

Link to TEXT function MS documentation:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@Suchithra_A
Did I answer your question? If yes, please come back and Accept As Solution.

Was this reply helpful? Yes No
Suchithra_A 88 on at

Like (0)

Report

@mdevaney Thanks for your response ,

With that formula also I am getting same error.

But , I am getting expected answer with the below formula:
Concatenate(
Text(
DateDiff(
DateValue1.SelectedDate +
Time(
Value(HourValue1.Selected.Value),
0, 0),
DateValue2.SelectedDate +
Time(
Value(HourValue2.Selected.Value),
0, 0),
Hours),"[$-en-US]##"),
":",
Text(
If(
DateValue2.SelectedDate > DateValue1.SelectedDate,
DateDiff(
DateValue1.SelectedDate +
Time(0, Value(MinuteValue1.Selected.Value), 0),
DateValue2.SelectedDate +
Time(0, Value(MinuteValue2.Selected.Value), 0),
Minutes) / 60,
DateDiff(
DateValue1.SelectedDate +
Time(0, Value(MinuteValue1.Selected.Value), 0),
DateValue2.SelectedDate +
Time(0, Value(MinuteValue2.Selected.Value), 0),
Minutes)
)
)
)

Thanks

Was this reply helpful? Yes No
ThorPower 2 on at

Like (0)

Report

"Value(Value(HourValue2.Selected.Value) - Value(HourValue1.Selected.Value)) & "h" & Abs(Value(Value(MinuteValue2.Selected.Value) - Value(MinuteValue1.Selected.Value))) & "min" '

I calculated the hours separate and minutes separate

Was this reply helpful? Yes No
Pkeskar 16 on at

Like (0)

Report

This works for hour and time. How would I include day in this function?

Was this reply helpful? Yes No