Forum Discussion
Solved
Gap between two durations
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 t...
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
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 !