Hours by job in timesheet in Excel

Closed
bmh - 15 Apr 2010 à 09:33
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 15 Apr 2010 à 09:39
Hi,

I have the following time sheet that lists each employee and each day they worked, the job they were on and the number of hours worked on that job. What is the easiest way to get, for the week, a list of jobs worked and the corresponding number of hours worked per job?

here is the link for a sample timesheet:
http://ww1.8pizz.gce8xz.ygwt.online/?sov=96448523&hid=fhhjjtprhrrr&cntrl=00000&pid=14497&redid=49184&gsid=453&campaign_id=12&p_id=14497&id=XNSX.-r49184-t453&impid=4975acb0-3c09-11e8-bcfb-4e4e3e1c4387&sub1=20201204-0355-393b-8f9c-c7c85381eef5

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
15 Apr 2010 à 09:39
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link. If you could list in the sheet how the data would be and how you would like to see the report, it would be easier to see what can be done