Calculate Total Total Hours Per Client [Solved/Closed]

Posts
8
Registration date
Thursday March 6, 2014
Last seen
June 21, 2016
- - Latest reply: ad1959
Posts
8
Registration date
Thursday March 6, 2014
Last seen
June 21, 2016
- 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



Thanks in advance
See more 

5 replies

Best answer
Posts
2440
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 13, 2018
1
Thank you
Hi ad1959,

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?

Also consider the option to post your workbook using a file sharing site like www.speedyshare.com or ge.tt and then post back your download link.

Always be careful with sensitive information!

Best regards,
Trowa

Say "Thank you" 1

A few words of thanks would be greatly appreciated. Add comment

CCM has helped 2902 users this month

Posts
22
Registration date
Sunday May 25, 2014
Last seen
September 25, 2014
0
Thank you
dear ,

please upload a sample
Posts
8
Registration date
Thursday March 6, 2014
Last seen
June 21, 2016
0
Thank you
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

Thanks for your help
Posts
2440
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 13, 2018
0
Thank you
Hi Ad1959,

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:
http://speedy.sh/C8vUg/ad1959-timesheet.xlsx

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

Best regards,
Trowa

Posts
8
Registration date
Thursday March 6, 2014
Last seen
June 21, 2016
0
Thank you
Hi Trowa,
The health is improving thank you.
Thanks for your help, your method is a lot simpler than the method I was trying to use.
thanks again and all the best

Regards
ad1959