Forum Discussion

Steven Hargett's avatar
Steven Hargett
Copper Contributor
Dec 07, 2022

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

Resources