How to exclude weekends in the "Hours_Since_Assigned" calculation in the attached workflow
1. generate each hours until now.
2. then remove the weekend and other filter like holiday.
3. then count the rows as 1 hours each row.
@AncientPandaman could you look into this?
@Jules22 yes, it is the right track. but please add a recordID before it. it used in the summarize later, to retain the sorting. next step is to remove the weekend in the [hours] column
@AncientPandaman got you, could you please share expressions used following two filters?
@Jules22 Remove weekend
DateTimeFormat([Hours],"%a") not in ("Sat","Sun")
Remove not working hours [Optional] i.e. keep 9am to 6pm
DateTimeHour([Hours]) >= 9 and DateTimeHour([Hours]) <= 18
