Forum Discussion

gjbannister01's avatar
gjbannister01
Copper Contributor
May 25, 2023

Create Calculated Column for Hours Based Off of Two Date Picker Columns

Hey. I have created a power apps that I am using from my SharePoint list and I want one of the columns to automatically calculate hours. I have two date picker columns, one for Start Date and the other for End date. I want a calculated column for hours to multiply the number of days in between the date picker columns by 8 minus Saturday and Sunday. For example, I started a project last Thursday and completed it Tuesday. This column would calculate 8 hours for every work day. So 4x8 - 32 hours, but not counting Saturday and Sunday. Or if it were a project Monday-Tuesday, it would still be able to calculate.

 

Thanks!

No RepliesBe the first to reply

Resources