Sample 1.xlsx (19.7 KB) Sample 2.xlsx (9.6 KB)

In this scenario, I want to get the total number of Regular Hours and the total number of OT Hours for a **“Rest Day”** Day Type in Sample 1 Excel file. Then, the total number of Regular Hours and the total number of OT Hours for a **“Rest Day”** Day Type will be pasted on its assigned cell in the Sample 2 Excel file. How can I do this? Thank you for the help.