Can someone help me with this forumula to calculate the difference between two times?
My formula in sharepoint is 24*(EndTime1-StartTime1). Not sure how to do this in Powerapps
Solved! Go to Solution.
Using above formula I get result as below,
start time : 11:00
end time :12.30
But I want in the format of 1:30.
How can I achieve this?
I have found the solution to the problem that the data shows 1.30 instead of 1.50.
This is my formula:
Start working time;
DatePicker1_1.SelectedDate + Time ( Value (Dropdown7_3.SelectedText.Value);
Value (Dropdown7_2.SelectedText.Value); 0 ) ) ;;
Set ( totaltraveltime;
RoundUp ( DateDiff ( DateTimeValue (Label60.Text);
Minutes ); 2 ) ) ;;
On an other textfield:
Time (0; totaltraveltime; 00)
I hope this works for you.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!