difference between two datetime columns in hours excluding weekends?

Question

How do we get difference in hours&nbsp; between two datetime columns excluding weekends?&nbsp;start&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; end07/01/2020 14:27:51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15/01/2020 09:27:3117/01/2020 18:42:13&nbsp;20/01/2020 11:42:37&nbsp;23/01/2020 06:58:1024/01/2020 15:56:2923/01/2020 09:54:3510/02/2020 12:28:2324/01/2020 14:50:5128/01/2020 13:15:0627/01/2020 16:45:47&nbsp;30/01/2020 07:40:18&nbsp;31/01/2020 20:21:1404/02/2020 08:46:2303/02/2020 16:25:5305/02/2020 13:42:4207/02/2020 16:10:1013/02/2020 09:18:18

amitchandak · Accepted Answer

sanjanarama , refer if this blog on the same topic can help
https://exceleratorbi.com.au/calculating-business-hours-using-dax/

Forum Discussion

difference between two datetime columns in hours excluding weekends?

1 Reply

Related content

DATEDIFF excluding weekends

Previous Day Balance - Excluding Weekends

Date / Time difference excluding weekends and factoring working hours

Exclude weekends from Date Measure

calculations excluding weekends

07/01/2020 14:27:51	15/01/2020 09:27:31
17/01/2020 18:42:13
20/01/2020 11:42:37
23/01/2020 06:58:10	24/01/2020 15:56:29
23/01/2020 09:54:35	10/02/2020 12:28:23
24/01/2020 14:50:51	28/01/2020 13:15:06
27/01/2020 16:45:47
30/01/2020 07:40:18
31/01/2020 20:21:14	04/02/2020 08:46:23
03/02/2020 16:25:53	05/02/2020 13:42:42
07/02/2020 16:10:10	13/02/2020 09:18:18