Calculate Total Total Hours Per ClientSolved/Closed

Question

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

Osama_bb11 · Answer

dear , 

please upload a sample

TrowaD · Answer

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

ad1959 · Answer

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

TrowaD · Answer

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

ad1959 · Answer

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

Calculate Total Total Hours Per Client

5 responses

Similar discussions

Subscribe To Our Newsletter!