SOLVED

# I need to know which formula should use on this situation

Copper Contributor

# 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

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

# Re: I need to know which formula should use on this situation

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.

# Re: I need to know which formula should use on this situation

thanks rachel
1 best response

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

# Re: I need to know which formula should use on this situation

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.