Forum Discussion
I need to know which formula should use on this situation
Hello, good evening Microsoft Team.
I am currently facing an issue regarding how to calculate the total duty hours of each employee for each day. We run a clothing business and need to know how many hours our employees work daily. To help me achieve this, I have prepared an Excel sheet. I would appreciate it if you could assist me in calculating the total working hours of every employee for one month using the reference data.
Please find the document attached. The first sheet contains the working progress of all employees with their working time. Kindly
Hi,
I think you can use SUMPRODUCT to calculate total working hours of a given employee for one month.
I attached the excel with formulas.
2 Replies
- rachelIron Contributor
Hi,
I think you can use SUMPRODUCT to calculate total working hours of a given employee for one month.
I attached the excel with formulas.
- favetaa2112Copper Contributorthanks rachel