Andrew Hardscape
Board Regular
- Joined
- Sep 28, 2003
- Messages
- 136
I have a sheet (as displayed). The top half of the sheet we enter in employee times.
The bottom half of the sheet is what we keep in employee files.
The bottom half is coded to read what is displayed in the top half.
But the bottom half is showing zeros when there are no times entered in the corresponding cells in the top half.
Is there a way to make it so the bottom half copies what is in the top half, but the cell remains blank if the cell in the top half is blank?
I hope I didnt confuse anyone!!!!
Thanks
The bottom half of the sheet is what we keep in employee files.
The bottom half is coded to read what is displayed in the top half.
But the bottom half is showing zeros when there are no times entered in the corresponding cells in the top half.
Is there a way to make it so the bottom half copies what is in the top half, but the cell remains blank if the cell in the top half is blank?
I hope I didnt confuse anyone!!!!
Thanks
English Laborer Time Sheet.xls | |||||||
---|---|---|---|---|---|---|---|
E | F | G | H | I | |||
9 | Start Work | Time Out (Lunch) | Time In (Lunch) | End Work | Total Hours | ||
10 | 7:00 AM | 12:00 PM | 12:30 PM | 3:30 PM | 8.00 | ||
11 | 0.00 | ||||||
12 | 8:00 AM | 11:55 AM | 12:15 PM | 4:08 PM | 7.80 | ||
13 | 0.00 | ||||||
14 | 0.00 | ||||||
15 | 0.00 | ||||||
16 | 7:00 AM | 11:55 AM | 12:41 PM | 4:12 PM | 8.43 | ||
17 | |||||||
18 | |||||||
19 | Start Work | Time Out (Lunch) | Time In (Lunch) | End Work | Total Hours | ||
20 | 7:00 AM | 12:00 PM | 12:30 PM | 3:30 PM | 8.00 | ||
21 | 12:00 AM | 12:00 AM | 12:00 AM | 12:00 AM | 0.00 | ||
22 | 8:00 AM | 11:55 AM | 12:15 PM | 4:08 PM | 7.80 | ||
23 | 12:00 AM | 12:00 AM | 12:00 AM | 12:00 AM | 0.00 | ||
24 | 12:00 AM | 12:00 AM | 12:00 AM | 12:00 AM | 0.00 | ||
25 | 12:00 AM | 12:00 AM | 12:00 AM | 12:00 AM | 0.00 | ||
26 | 7:00 AM | 11:55 AM | 12:41 PM | 4:12 PM | 8.43 | ||
TimeSheet |