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!


Cocabo
Frequent Visitor

its works for me ..thanks

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,605)