cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
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
Highlighted
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

Highlighted
Helper I
Helper I

Re: Datediff Minutes Format hh:mm

Thanks! It works fine 🙂

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response 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 (7,750)