Answered

difference between time

(0) Share

Report

Posted on by Paresh_K

Hi , I am new to PowerApps. Recently I have developed an App where in I need to calculate the diff in the time in Minutes. I have a Form where in the user would select the Activity start time via a Date Picker with time input . and in a second filed in the Same Form selects the Date and time. I need to find the time difference between the two in Minutes.

I find it difficult as both the fields are apart of a Form connected to a SharePoint List.

Would appreciate ,if anybody have overcome this issue..

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

DateDiff( StartDateTime, EndDateTime [, Units ] ), units would be Minutes

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

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi@Paresh_K,
Based on the issue you mentioned, you want to display the date-time difference in minutes in your form.
I think the best way is to add labels to respectively display Activity start time, Activity end time, and time difference in minutes.
I have a test on my side, please take a try as below:
Create an app directly from your SP list.
Insert 3 labels below the two date datacards
Set the Text property of the Labels as below:
Label1 for Activity start date-time:

Text( DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0), DateTimeFormat.ShortDateTime)

Label1_1 for Activity end time date-time:

Text( DateValue2.SelectedDate + Time(Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value), 0), DateTimeFormat.ShortDateTime)

Label1_2 for the time difference in minutes:

DateDiff( DateTimeValue(Label1.Text), DateTimeValue(Label1_1.Text), Minutes)

Note: Value1/2 represents Activity start/end time value.

Best Regards,
Qi Qiao

Was this reply helpful? Yes No