# Calculate Total Total Hours Per Client

Solved/Closed
ad1959 Posts 10 Registration date Thursday March 6, 2014 Status Member Last seen August 18, 2020 - Sep 24, 2014 at 12:19 AM
ad1959 Posts 10 Registration date Thursday March 6, 2014 Status Member Last seen August 18, 2020 - Oct 3, 2014 at 04:15 AM
Hi,
I have a spreadsheet in which employyees time are entered on a daily basis along with the client they worked for. The spreadsheet calculates the total hours worked each day.

Can anyone assist me to calculate and display on another sheet the following-
1. Total Hours worked per day per client
2. Total Hours worked per Client per week

Related:

## 5 replies

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
Sep 25, 2014 at 11:32 AM

I've enlarged your picture as much as allowed but it is still not clear.

Could you post several smaller pictures (a few columns at a time) to show the layout of your sheet?

Always be careful with sensitive information!

Best regards,
Trowa
Osama_bb11 Posts 22 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014
Sep 25, 2014 at 01:10 AM
dear ,

ad1959 Posts 10 Registration date Thursday March 6, 2014 Status Member Last seen August 18, 2020 1
Oct 2, 2014 at 06:12 AM
Thanks for looking at this for me. i have been in hospital and and can now respond to you.
I have attached a sample of the spreadsheet for you to look at.
http://speedy.sh/ez6VY/timesheet.xlsx

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
Oct 2, 2014 at 11:29 AM

Hopefully you are in great health again!

To get the total hours a day per client I used the following array formula:
=SUM(IF('Hours Worked'!G\$4:G\$32='Total Hours'!\$A\$3,1,0)*'Hours Worked'!D\$4:D\$32)
Where 'Total Hours'!\$A\$3 refers to a specific client.
NOTE that array formula's need to be confirmed by hitting Ctrl+Shift+Enter for them to work properly.

To get the totals for the week a simple SUM formula would suffice.

Here is your file where I added the formula's in the "Total Hours" sheet for all clients for Saturday and Sunday (you can do the rest of the week) as well as the week totals:

Let me know if you got any questions or if you might get stuck.

Best regards,
Trowa

Didn't find the answer you are looking for?