Hours by job in timesheet in Excel

Closed
bmh - Apr 15, 2010 at 09:33 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 15, 2010 at 09:39 AM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 15, 2010 at 09:39 AM
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
0