Gap between two durations

[daniel_hob]

Hi everyone, 
I am trying to calculate gap (difference) between two durations:

Duration beween actual working time of the employees and the time they spend/stay in the workplace,
For calculating the effectiveness of the workday.

it's not like calculate difference between date.

I really appreciate any help.
Thank you,

Best Regards

[mahoneypat · Accepted solution]

It is much easier to deal with durations as decimal numbers, and then display the result in your desired format at the end. Please see this article.

Calculate and Format Durations in DAX – Hoosier BI

Pat

[serpiva64]

Hi,

you can use a calculated column

Column = format(VALUE('Table'[Column2])-VALUE('Table'[Column1]),"hh:nn:ss")

or a measure

Column = format(VALUE('Table'[Column2])-VALUE('Table'[Column1]),"hh:nn:ss")

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !