Calculating the difference between two times

[tbrantley]

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

[Anonymous]

Thanks so much! 🙂

[Suchithra_A]

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]

@Suchithra_A 

What happends when you remove the / 60?

[sjoepcoup]

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.