Previous Topic Next Topic

Calculate Total Total Hours Per Client

Solved/Closed
ad1959 Posts 10 Registration date Thursday 6 March 2014 Status Member Last seen 18 August 2020 - 24 Sep 2014 à 00:19
ad1959 Posts 10 Registration date Thursday 6 March 2014 Status Member Last seen 18 August 2020 - 3 Oct 2014 à 04:15
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
Related:

5 responses

Réponse 1 / 5
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
25 Sep 2014 à 11:32
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
Réponse 2 / 5
Osama_bb11 Posts 21 Registration date Sunday 25 May 2014 Status Member Last seen 25 September 2014
25 Sep 2014 à 01:10
dear ,

please upload a sample
Réponse 3 / 5
ad1959 Posts 10 Registration date Thursday 6 March 2014 Status Member Last seen 18 August 2020 1
2 Oct 2014 à 06:12
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
Réponse 4 / 5
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
2 Oct 2014 à 11:29
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

Réponse 5 / 5
ad1959 Posts 10 Registration date Thursday 6 March 2014 Status Member Last seen 18 August 2020 1
3 Oct 2014 à 04:15
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