Calculated Column Using Two Date Picker Columns to Calculate Hours

Copper Contributor

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.



0 Replies