I am working on a Bonus/Abscence/Timesheet workbook for our office. I have
most everything worked out, but I have a few glitches if someone would/could
help me please.

1. On the timesheet, I need the G column to calculate the times, but my
formula isnt working. I also need it to round to the quarter hour instead
of to the minute.
2. I have the timesheet linked to the bonus sheet so that the total on the
bonus sheet will autofill on the timesheet. The problem is, we turn this
bonus sheet in every payroll so the total for the current payroll will be
different. I have added a column to show €œpd€� (paid), so that once we are
paid for that bonus, we can mark it paid. What formula can I use so that
once its marked pd, that amount wont calculate into the current total?
3. I would also like it if when a number is entered on the €œAbsence
Calendar€�, it would automatically fill in on the timesheet. Im not sure if
I even have things setup right to make this happen.
4. Then I need the YTD totals to calculate every payroll.

FYI stuff - Each person has their own workbook. We normally submit our
timesheets every other Friday morning and currently have no way of tracking
the YTD without going back and doing it manually. I realize this lengthy,
but I thought I would try to get some help with it all at once instead of
bits and pieces and having to go back and change something previously done to
work with the new thing. Make sense?

Oh yea, is uploaded to: http://www.savefile.com/files/1380357

The €œReference€� worksheet and the F column on the timesheet normally hidden
and the cells highlighted in pale yellow on all of the worksheets are the
only ones that will be unlocked and editable. And actually, I hope columns
I-K on the timesheet can be linked and non-editable.

Just a rough draft.
I recommend a commercial product.
http://www.savefile.com/files/1382610

I agree with the commercial product suggestion, but I haven't been able to
find one inexpensive enough for our frugal boss to buy.

I do appreciate your help and I am going to see I can do with this stuff.

THANK YOU!!


"Herbert Seidenberg" wrote:

Just a rough draft.
I recommend a commercial product.
http://www.savefile.com/files/1382610

Ok, I have worked with it and got it ALMOST there, with your help of course!!
I just have a couple things I can't work out. Do you mind looking at it and
seeing what you think please? I uploaded the file and my "needs" are in red
on the worksheets. I thought putting them there would make it easier for me
to explain and for you to understand.

http://www.savefile.com/files/1395263


"Herbert Seidenberg" wrote:

Just a rough draft.
I recommend a commercial product.
http://www.savefile.com/files/1382610

Excel 2003 or later
http://www.savefile.com/files/1395654

You are the bomb!! I soooo appreciate your help! Please see the file I
uploaded.

http://www.savefile.com/files/1396401


"Herbert Seidenberg" wrote:

Excel 2003 or later
http://www.savefile.com/files/1395654

Revised and generalized.
Shelf life: about 3 months.
http://www.savefile.com/files/1862189