Hours by job in timesheet in Excel

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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