SOLVED

I need to know which formula should use on this situation

Copper Contributor

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

2 Replies
best response confirmed by favetaa2112 (Copper Contributor)
Solution

@favetaa2112 

 

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.

1 best response

Accepted Solutions
best response confirmed by favetaa2112 (Copper Contributor)
Solution

@favetaa2112 

 

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.

View solution in original post