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

[AndyPennell · Accepted solution]

DateDiff(StartTime1,EndTime1,Hours)

[ericonline]

Hi @AndyPennell and @tbrantley. How about this scenario? 

Two Date+Time cards: 

Trying to use DateDiff between them to display hours and minutes in "##:##" format using: 

Concatenate(    
    Text(    
        DateDiff(
            DateTimeValue(
                    Concatenate(
                        Text(
                            startDate.SelectedDate,DateTimeFormat.ShortDate),
                        Char(13),
                        Text(
                            Concatenate(
                                startHour.Selected.Value,
                                ":",
                                startMinute.Selected.Value),ShortTime)),"en-US"),
            DateTimeValue(
                    Concatenate(
                        Text(
                            endDate.SelectedDate,DateTimeFormat.ShortDate),
                        Char(13),
                        Text(
                            Concatenate(
                                endHour.Selected.Value,
                                ":",
                                endMinute.Selected.Value),ShortTime)),"en-US"),
        Hours),"[$-en-US]##"),
        
        ":",
    Text(
        DateDiff(
            DateTimeValue(
                    Concatenate(
                        Text(
                            startDate.SelectedDate,DateTimeFormat.ShortDate),
                        Char(13),
                        Text(
                            Concatenate(
                                startHour.Selected.Value,
                                ":",
                                startMinute.Selected.Value),ShortTime)),"en-US"),
            DateTimeValue(
                    Concatenate(
                        Text(
                            endDate.SelectedDate,DateTimeFormat.ShortDate),
                        Char(13),
                        Text(
                            Concatenate(
                                endHour.Selected.Value,
                                ":",
                                endMinute.Selected.Value),ShortTime)),"en-US"),
        Minutes),"[$-en-US]##")
)

But this results in: 

How do I get the correct times to display? 

Thanks

[WPB]

Works for me. Far from ideal but you know...

RoundDown(DateDiff(Date_Debut,Date_Fin,Seconds)/3600,0) 
& ":" &
RoundDown((DateDiff(Date_Debut,Date_Fin,Seconds)/3600 - RoundDown(DateDiff(Date_Debut,Date_Fin,Seconds)/3600,0))*60,0)
& ":" &
Round((DateDiff(Date_Debut,Date_Fin,Seconds)/60 - RoundDown(DateDiff(Date_Debut,Date_Fin,Seconds)/60,0))*60,0)

[WPB]

Text(Time(0, 0, DateDiff(Punch_Record.Date_Debut,Now(),Seconds)), "[$-en-US]hh:mm:ss")

[AndySid]

I needed to do this as well, and found this solution works well when using the hour and minute dropdown on a datacard....

DateDiff(Time(
Value(HourValue11.Selected.Value),
Value(MinuteValue11.Selected.Value),
0),Time(
Value(HourValue12.Selected.Value),
Value(MinuteValue12.Selected.Value),
0),Minutes) / 60.0

[Anonymous]

Hi, I used your code and it kind of works

but for eg 1 hour and 10 minutes it shows: 1:70

so it adds the hour in minutes to the minutes??

How can I solve this?

[Anonymous]

Hi @ericonline ,

I used your code and it kind of works

but for eg 1 hour and 10 minutes it shows: 1:70

so it adds the hour in minutes to the minutes??

How can I solve this?

[ericonline]

Hi @Anonymous ,

This thread was continued in another post. Check out @CarlosFigueira 's excellent response and sample app. This will fix you up!

[Cocabo]

its works for me ..thanks