cancel
Showing results for
Did you mean:
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

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

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

Solution Sage
``````EVALUATE
var Time1 = date(2021, 7, 23) + 12/24
// 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]
)``````

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors