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

 

1 ACCEPTED SOLUTION

Accepted Solutions
AndyPennell
Power Apps
Power Apps

DateDiff(StartTime1,EndTime1,Hours)

View solution in original post

13 REPLIES 13
AndyPennell
Power Apps
Power Apps

DateDiff(StartTime1,EndTime1,Hours)

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

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

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

AndySid
Resolver II
Resolver II

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
Not applicable

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
Not applicable

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?

Hi @Anonymous ,

 

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


its works for me ..thanks

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.

Power Apps Ideas

Check out the New Ideas Site

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

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