Timelapse between two moments on different dates

[Brandaris]

Hello,

Is is possible to calculate the amount of hours and minutes between 2 moments on 2 different days? An then showed in hh:mm?

For Example:

Start moment: 14-03-2022 14:03:42  (dd-mm-yyyy hh:mm:ss)

End moment:  16-03-2022  13:40:39 (dd-mm-yyyy hh:mm:ss)

Timelapse: 47:36:57 (hh:mm:ss)

Thank you very much for your help.

Kind regards,

Brandaris

[ppm1]

The best approach is to just do a custom column with [End moment] - [Start moment] which will result in a duration. When you close and load it will convert to decimal format (in days). You can then do your measures and use FORMAT([Your Expression], "hh:mm:ss") to display it as text (vs. converting it to text in Power Query and then not being able to do calculations on it easily). See the article below for more info.

Calculate and Format Durations in DAX – Hoosier BI

Pat