cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Apps
Power Apps

Re: Calculating the difference between two times

DateDiff(StartTime1,EndTime1,Hours)

View solution in original post

12 REPLIES 12
Highlighted
Power Apps
Power Apps

Re: Calculating the difference between two times

DateDiff(StartTime1,EndTime1,Hours)

View solution in original post

Highlighted
Super User
Super User

Re: Calculating the difference between two times

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

 

Two Date+Time cards: 

dateDiffWithHoursAndMinutes.png

 

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: 

dateDiffWithHoursAndMinutes1.png

 

How do I get the correct times to display? 


Thanks

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Calculating the difference between two times

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)
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Calculating the difference between two times

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

Highlighted
Resolver II
Resolver II

Re: Calculating the difference between two times

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

Highlighted
Anonymous
Not applicable

Re: Calculating the difference between two times

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?

Highlighted
Anonymous
Not applicable

Re: Calculating the difference between two times

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?

Highlighted
Super User
Super User

Re: Calculating the difference between two times

Hi @Anonymous ,

 

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


Highlighted
Frequent Visitor

Re: Calculating the difference between two times

its works for me ..thanks

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,678)