Showing results for 
Search instead for 
Did you mean: 
Level 10

Re: Calculate flight time


Oh yes you right... Problems are with minutes. I thought the problems are with hours.. I played with that time function for a while few weeks ago and I didn't notice that. I was sure it worked as I wanted to. However I've got another solution for that. It is a bit crazy but it works so far and din't notice any problem. What I'm doing here is adding those minutes into Today() where today always return 0:00 . And then formating it to hours:minutes format. Try it and let me know if you find any problem. I think this is much more easier and cleaner then the other workaround


DateDiff(DateTimeValue("2018-01-22 23:05"),DateTimeValue("2018-01-23 12:34"),Minutes),


Level 10

Re: Calculate flight time

However I wasn't able to pull a day from it. That means if the duration exceed 24 hours it will go back to 00:00. So I found this the only solution to retrive also days from date - time format 


(DateDiff(DateTimeValue("2018-01-22 23:05"),DateTimeValue("2018-01-23 23:06"),Minutes)
&"day(s) "&
Text(DateAdd(Today(),DateDiff(DateTimeValue("2018-01-22 23:05"),DateTimeValue("2018-01-23 23:06"),Minutes),

I guess this is good example for new function suggestion to make it more easier and clearer

Helpful resources


Power Apps Community User Group Member Badge

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


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


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,410)