J
john klein
I work for a pretty small company, and I am the so called Excel " expert " (
which means I know about 1% of most of you)...my problem is...we are doing a
piece rate time sheet, It is from an ancient Lotus 123 that I converted into
excel, and it works fine...all the info works.
But the steps needed to come up with check totals is arcane, and doing a
productivity report or contract totals is near impossible.
To start I would love this worksheet to automatically create a check
writing totals worksheet ( without all the other data )for example: we have
6 or 7 clients that do contract work and get paid piece rate, they each have
a employee number, after they day is done, I enter there number, the times
started and stopped, and the particular job they did, the worksheet figures
the hours and the efficiency percentage, then figures the adjusted pay.
I would like the information sent to another sheet that would show each
clients time worked, efficiency % and pay,
totalled in a clear easy to read way so that our secratary has an easy time
of it and I look like a genius.
I am sure that this is an easy thing for an expert to do but I have
struggled with it for a week, I farted with the "IF" function, pivot reports,
a few addons, and only succedeed in making myself confused...any help will
be much appreciated.
thanks
John
which means I know about 1% of most of you)...my problem is...we are doing a
piece rate time sheet, It is from an ancient Lotus 123 that I converted into
excel, and it works fine...all the info works.
But the steps needed to come up with check totals is arcane, and doing a
productivity report or contract totals is near impossible.
To start I would love this worksheet to automatically create a check
writing totals worksheet ( without all the other data )for example: we have
6 or 7 clients that do contract work and get paid piece rate, they each have
a employee number, after they day is done, I enter there number, the times
started and stopped, and the particular job they did, the worksheet figures
the hours and the efficiency percentage, then figures the adjusted pay.
I would like the information sent to another sheet that would show each
clients time worked, efficiency % and pay,
totalled in a clear easy to read way so that our secratary has an easy time
of it and I look like a genius.
I am sure that this is an easy thing for an expert to do but I have
struggled with it for a week, I farted with the "IF" function, pivot reports,
a few addons, and only succedeed in making myself confused...any help will
be much appreciated.
thanks
John