M
Mr. Haney
Hi guys...
I am looking for advice as to which function(s) to use here:
I have a sheet where I keep track of time put toward job tasks at work.
I look up the job number from a sheet where I keep said numbers.
I jump around from task to task at work and from day to day. So all of
the time put towards a single job number may be listed on the sheet
across several rows throughout a given day or through the week.
My per row (per job entry) time tally works fine, and my per column
(per day) tally works fine, all contained on that one sheet. I want to
make a final tally sheet that queries all the entries made in a given day
(column) for each job number listed in my leftmost column, where the
duplicate entries would be so that I end up with a per job tally that
shows all hours worked on each job each day.
So I need to sum the hours with a for each type thing.
I can build the sheet/table, but I want to know what the best function
is to query my task tracking sheet.
So, I will make seven tally sheets, one for each day, that lists only
the jobs worked on in that day, and its totals.
My current sheet has no problem with my overall daily tally or my
weekly tally, but I have yet to construct the daily tally sheets.
I am looking for advice as to which function(s) to use here:
I have a sheet where I keep track of time put toward job tasks at work.
I look up the job number from a sheet where I keep said numbers.
I jump around from task to task at work and from day to day. So all of
the time put towards a single job number may be listed on the sheet
across several rows throughout a given day or through the week.
My per row (per job entry) time tally works fine, and my per column
(per day) tally works fine, all contained on that one sheet. I want to
make a final tally sheet that queries all the entries made in a given day
(column) for each job number listed in my leftmost column, where the
duplicate entries would be so that I end up with a per job tally that
shows all hours worked on each job each day.
So I need to sum the hours with a for each type thing.
I can build the sheet/table, but I want to know what the best function
is to query my task tracking sheet.
So, I will make seven tally sheets, one for each day, that lists only
the jobs worked on in that day, and its totals.
My current sheet has no problem with my overall daily tally or my
weekly tally, but I have yet to construct the daily tally sheets.