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

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps
`DateDiff(StartTime1,EndTime1,Hours)`
13 REPLIES 13
Power Apps
`DateDiff(StartTime1,EndTime1,Hours)`
Community Champion

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

Kudo Kingpin

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

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

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?

Community Champion

Hi @Anonymous ,

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

Frequent Visitor

its works for me ..thanks

## Helpful resources

Announcements

#### Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

#### Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

#### Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,758)