cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tbrantley
Helper IV
Helper IV

Calculating the difference between two times

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

 

Capture5.PNG

 

13 REPLIES 13
Anonymous
Not applicable

Thanks so much! 🙂

Hi,

Using above formula I get result as below,

start time : 11:00

end time :12.30

result: 1.5

 

But I want in the format of 1:30.

How can I achieve this?

 

 

Anonymous
Not applicable

@Suchithra_A 

 

What happends when you remove the / 60?

sjoepcoup
Advocate I
Advocate I

Schermafbeelding 2021-04-08 131429.png

Schermafbeelding 2021-04-08 133730.png

Hello,

I have found the solution to the problem that the data shows 1.30 instead of 1.50.

 

This is my formula:

On button:

Set (

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);

DateTimeValue (Label60_1.Text);

Minutes ); 2 ) ) ;;

 

On an other textfield:

Time (0; totaltraveltime; 00)

 

I hope this works for you.

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,952)