SharePoint Online calculated column Question
I am working on a Power Bi report, and I am trying to use a calculated column in SharePoint for a metric. I have 2 date/time columns Start Date and Complete Date. I need to calculate the difference between the two so that we can see the days, hours and minutes between them. However, the calculation should only count 8 hours per day Monday - Friday. Using a datedif it would see the difference of Wed last week at 1200 to Wed this week at 1200 as 10080 minutes, 168 Hours, or 7 days, when actually it was 2400 minutes, 40 hours, or 5 days. Is there a way to calculate the work time between 2 date time columns to the days, hours, and minutes?