Forum Discussion
Calculate Average Time To between to columns that contain Time and Date, excluding weekends
Hello i have two colums that contain a date and time. I added a calculated column to show the difference in days hours, minutes, and seconds. My issues are (1) i need to exlude any weekend or h...
amitchandak
Super User
Super UserSWI-Inc , if you are looking for business hours, check if this blog can help
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
This hasnt worked for me. i used the final formula matt posted. Here is my file. i need the time between the pick date and ship date expressed in hours
https://drive.google.com/drive/folders/1P0_5c8OZQAp3dpwPDTgVF9NWNvl4k_iQ?usp=sharing