Forum Discussion
Steven Hargett
Dec 07, 2022Copper Contributor
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?
No RepliesBe the first to reply