C
CClarke
Hi! I just started using spreadsheets a week or so ago, and just found
this website! I am progressing in my Excel education, but I haven't
figured out how to accomplish the following:
I have a spreadsheet with two pages. The first one is basically a
calendar. There are two rows for each month, and one column for each
day. It is used to keep track of employees' work, vacation, sick time,
etc. In the first row of each month, I put a code for the kind of time
(worked,sick,etc). In the second row I put the number of hours.
1 2 3 4 5
W W
January 8 7.5 and so on.
A variety of calculations are performed using this info.
The second sheet is a time-sheet which is given to payroll at the end
of the pay period. It includes the days of the week, date, time work
started and ended, lunch break, and total hours worked for each day (I
wrote my first VB macro to calculate it!)
Monday Tuesday
Date 1/12/04 1/13/04
Start Time 9:00 am 9:15 am
Lunch .50
End Time 5:00 pm 4:45 pm
Hours 7.5 7.5 etc.
Here's my question. Is there a way to get the number of hours to
transfer from the time-sheet to the calendar? It would need to look at
the month and day on each column of the time-sheet, find the
corresponding point on the calendar (ie. 1/12 is January 12th, which is
row 3 column 13), and put the number of hours worked there. I need to
be able to put things on the calendar that won't be on the time-sheet
(like sick days), and when the dates on the time-sheet change, the
numbers on the calendar for the previous weeks have to stay. So the
calendar can't be set up to look at the time-sheet. The time-sheet
needs to be able to SEND info to the calendar.
Is this possible?
this website! I am progressing in my Excel education, but I haven't
figured out how to accomplish the following:
I have a spreadsheet with two pages. The first one is basically a
calendar. There are two rows for each month, and one column for each
day. It is used to keep track of employees' work, vacation, sick time,
etc. In the first row of each month, I put a code for the kind of time
(worked,sick,etc). In the second row I put the number of hours.
1 2 3 4 5
W W
January 8 7.5 and so on.
A variety of calculations are performed using this info.
The second sheet is a time-sheet which is given to payroll at the end
of the pay period. It includes the days of the week, date, time work
started and ended, lunch break, and total hours worked for each day (I
wrote my first VB macro to calculate it!)
Monday Tuesday
Date 1/12/04 1/13/04
Start Time 9:00 am 9:15 am
Lunch .50
End Time 5:00 pm 4:45 pm
Hours 7.5 7.5 etc.
Here's my question. Is there a way to get the number of hours to
transfer from the time-sheet to the calendar? It would need to look at
the month and day on each column of the time-sheet, find the
corresponding point on the calendar (ie. 1/12 is January 12th, which is
row 3 column 13), and put the number of hours worked there. I need to
be able to put things on the calendar that won't be on the time-sheet
(like sick days), and when the dates on the time-sheet change, the
numbers on the calendar for the previous weeks have to stay. So the
calendar can't be set up to look at the time-sheet. The time-sheet
needs to be able to SEND info to the calendar.
Is this possible?