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.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
We are excited to announce a new way to share your ideas for Power Apps!