J
Jim Stoicheff
I'm attempting to automate my timecard process. I've
created a spreadsheet with lines for Job number, start
time, end time, and total time. It includes 20 columns,
to allow for the different projects I can work on in a
day. I may work on the same project several times during
the day, say from 9:00 to noon and then from 13:00 to
13:40. In the case of my example, I would enter the data
twice, once for each work period. When I enter the job
number, start time, and end time, the total time is
automatically calculated.
I've created on the same worksheet a section that
includes a line for each possible job number and the same
20 columns described above. Each cell contains a formula
using the IF function. If the job number entered in the
above spreadsheet is the same as the job number in column
A, the total time for that column is entered in the row.
At the end of the row is a total for that job number for
the day.
Here's where I need help. There are hundreds of potential
job numbers, and I don't want to have to search through
the entire list to find the job numbers associated with
values other than zero. I don't know how to use the data
generated by what I've created so far to create another
list that includes only those job numbers that were
actually used, with the total time associated.
What functions should I be looking at? Is there an easier
way to do this?
Your help is appreciated.
created a spreadsheet with lines for Job number, start
time, end time, and total time. It includes 20 columns,
to allow for the different projects I can work on in a
day. I may work on the same project several times during
the day, say from 9:00 to noon and then from 13:00 to
13:40. In the case of my example, I would enter the data
twice, once for each work period. When I enter the job
number, start time, and end time, the total time is
automatically calculated.
I've created on the same worksheet a section that
includes a line for each possible job number and the same
20 columns described above. Each cell contains a formula
using the IF function. If the job number entered in the
above spreadsheet is the same as the job number in column
A, the total time for that column is entered in the row.
At the end of the row is a total for that job number for
the day.
Here's where I need help. There are hundreds of potential
job numbers, and I don't want to have to search through
the entire list to find the job numbers associated with
values other than zero. I don't know how to use the data
generated by what I've created so far to create another
list that includes only those job numbers that were
actually used, with the total time associated.
What functions should I be looking at? Is there an easier
way to do this?
Your help is appreciated.