cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GieseDom
New Member

How to calculate time difference for a calculated date/time difference in total hours

Hello,

I did a lot of research and finally ended up with the suitable command i needed... BUT
It doesn´t show me the total hours (26:00:00) as soon it is crossing the date.
So i need to find out the hours between two departure date/times so that i can analyze the duration between... This is required to create some output that helps me to identify required hotelbookings...

 

So what i want to achieve:
Departure 1 = 07/23/2021 12:00:00
Departure 2 = 07/25/2021 08:00:00

= 44:00:00 hours -> (minus the duration of the trip as example 9 hours = 35 hours -> I need a room for two nights

 

HELP.jpg

 

 

I´m so frustrated......
and i just can´t hide it....

I´m about to lose my mind AND I DONT LIKE IT !!! 😛

1 REPLY 1
daxer
Solution Sage
Solution Sage

EVALUATE
var Time1 = date(2021, 7, 23) + 12/24
// Adding a float to a date is like adding
// time to it. For instance, if you want
// to add, say, 10 hours to a date, 
// you add 10/24 since there are 24 hours
// in a day. If you want to add, say, 251
// minutes, you add 251/(24*60) since
// there are 24 * 60 minutes in a day.
// The same patterns continues for any amount
// of time.
var Time2 = date(2021, 7, 24) + 10/24 // add 10 hours
var TimeDiffInDays = 1 * (Time2 - Time1)
var TimeDiffInHours = TimeDiffInDays * 24
return
    SELECTCOLUMNS(
        {(Time1, Time2, TimeDiffInDays, TimeDiffInHours)},
        "Start Date", [Value1],
        "End Date", [Value2],
        "Time Diff In Days", [Value3],
        "Time Diff In Hours", [Value4]
    )

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!