Calculate Total Total Hours Per Client [Solved/Closed]

Report
Posts
10
Registration date
Thursday March 6, 2014
Status
Member
Last seen
August 18, 2020
-
Posts
10
Registration date
Thursday March 6, 2014
Status
Member
Last seen
August 18, 2020
-
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

5 replies

Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
440
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
1
Thank you

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

CCM 2889 users have said thank you to us this month

Posts
22
Registration date
Sunday May 25, 2014
Status
Member
Last seen
September 25, 2014

dear ,

please upload a sample
Posts
10
Registration date
Thursday March 6, 2014
Status
Member
Last seen
August 18, 2020
1
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
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
440
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
10
Registration date
Thursday March 6, 2014
Status
Member
Last seen
August 18, 2020
1
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