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....
Go to Solution.
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
Thanks! It works fine 🙂
Keep your eyes open for our upcoming T-shirt design contest!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020