S
Sheila
I have a section of a worksheet which will accumulate 13
weeks of timesheet hours information. One section accepts
time card registrations, subtracts and yields hours
worked. Each person might have multiple departments or
budget areas, so there are 9 columns of information per
employee. The hours are totaled by day, then by week. At
the end of each week, I would like to hold that week info
in another location to total by quarter.
I have tried comparing dates to get it to store this
week's data in the quarter array, but Excel is too fluid.
I think I need a way to use an IF stmt which changes the
cell when true, but leaves it as before on false. Right
now I end up with zeroes in every cell that is not in this
week.
We have a payroll program, this is only used to accumulate
hours data. I would really like to develop it to produce
an input for Peachtree, but I'll settle for holding the
quarters for now.
Thanks,
Sheila
weeks of timesheet hours information. One section accepts
time card registrations, subtracts and yields hours
worked. Each person might have multiple departments or
budget areas, so there are 9 columns of information per
employee. The hours are totaled by day, then by week. At
the end of each week, I would like to hold that week info
in another location to total by quarter.
I have tried comparing dates to get it to store this
week's data in the quarter array, but Excel is too fluid.
I think I need a way to use an IF stmt which changes the
cell when true, but leaves it as before on false. Right
now I end up with zeroes in every cell that is not in this
week.
We have a payroll program, this is only used to accumulate
hours data. I would really like to develop it to produce
an input for Peachtree, but I'll settle for holding the
quarters for now.
Thanks,
Sheila