cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CPKH
Level: Powered On

Datediff Minutes Format hh:mm

Hey all!

I want to have the right value of Minutes of hh:mm format.

DateDiff(Arrival,Exit, Minutes) refer to a galleryItem which exists at a sharepointlist (time and date format).

Now i want 08.15-11.31 = 196 Minutes in the format "hh:mm". How i get it?

Text(DateDiff(Arrival,Exit, Minutes),"hh:mm") gives me 01:00 back....

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Datediff Minutes Format hh:mm

Hi @CPKH 

Something like this should take you close to what you need.

 

 

RoundDown(DateDiff(Arrival,Exit, Minutes)/60,0) & 
":" &
Text(Mod(DateDiff(Arrival,Exit, Minutes),60), "00")

Hope that's of some help.

 

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Datediff Minutes Format hh:mm

Hi @CPKH 

Something like this should take you close to what you need.

 

 

RoundDown(DateDiff(Arrival,Exit, Minutes)/60,0) & 
":" &
Text(Mod(DateDiff(Arrival,Exit, Minutes),60), "00")

Hope that's of some help.

 

View solution in original post

CPKH
Level: Powered On

Re: Datediff Minutes Format hh:mm

Thanks! It works fine 🙂

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

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