cblincoln43
Board Regular
- Joined
- Mar 12, 2002
- Messages
- 206
Column D has Dates. Column H is for codes.
Row 7 = 3/24-----------7="M","S","A","E",
Row 8 = 3/25-----------8="H" or "W"
Row 9 = 3/26-----------9=?
Row 10 = 3/27---------10=?
Row 11 = 3/28---------11=?
Row 12 = 3/29---------12=?
If the cells in column H has any of the above letters entered into them. Then the date for that row will transfer to the cell deginated for that letter. "M"=D18,"S"=D22,"A"=D25, "E"=D28,"H"=D31, and "W"=D34. Other wise these cells remain blank.
The formulas Ya'll, helped me with work fine for one letter and one row. But when i try to add the rest of the letters and/or rows i keep getting #VALUE. Is this another one of them can't do deals? Like in inputing time as tenths of an hour.(2.5pm) There got be a way this outfit has 1500 employee's using a time clock that in 10ths.of a hour.
This message was edited by cblincoln43 on 2002-04-28 11:34
This message was edited by cblincoln43 on 2002-04-28 11:43
Row 7 = 3/24-----------7="M","S","A","E",
Row 8 = 3/25-----------8="H" or "W"
Row 9 = 3/26-----------9=?
Row 10 = 3/27---------10=?
Row 11 = 3/28---------11=?
Row 12 = 3/29---------12=?
If the cells in column H has any of the above letters entered into them. Then the date for that row will transfer to the cell deginated for that letter. "M"=D18,"S"=D22,"A"=D25, "E"=D28,"H"=D31, and "W"=D34. Other wise these cells remain blank.
The formulas Ya'll, helped me with work fine for one letter and one row. But when i try to add the rest of the letters and/or rows i keep getting #VALUE. Is this another one of them can't do deals? Like in inputing time as tenths of an hour.(2.5pm) There got be a way this outfit has 1500 employee's using a time clock that in 10ths.of a hour.
This message was edited by cblincoln43 on 2002-04-28 11:34
This message was edited by cblincoln43 on 2002-04-28 11:43