K
klg
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 isn’t 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 it’s marked pd, that amount won’t 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. I’m 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.
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 isn’t 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 it’s marked pd, that amount won’t 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. I’m 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.