Hi, I have a data downloaded from the erp, need to calculate the Average working hrs, no of days (excluding weekends) and no.of hrs and no.of days in weekend.
Need formula to get the above information. result table will look like below
Also we should not consider less than 3 hrs data.
erp data
Need formula to get the above information. result table will look like below
Also we should not consider less than 3 hrs data.
erp data