Forum Discussion
Calculate difference between two dates in Minutes
Hi all So i have two dates, One is the [Created Date] and One is the [Completed Date]. I was able to calculate the difference between these based on Work Days(ie Exclude Holidays and Weekends...
Anonymous , There is blog around business hour. See if that can help
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
Anonymous
The simplest method is using power query, add a custom column and change the data type from duration to Text. So the below solution is 58days, 23 hrs, 19mins.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.