Hello:

Please refer to attached sheet.

I have Sheet1 and Sheet2

Sheet1, i have date in cell A3:A33 and employee name in cell C2:D2

Sheet2, has clockIn-Out for employees and data is in sheet2 cell O65:Z68.
Red Highled fields are the calculated hours worked.

I want to summary the total hours each employee worked for a given date in Sheet1.

Please help me with the formula to give the result.

Thanks

Riz

Book2.xlsx