cblincoln43
Board Regular
- Joined
- Mar 12, 2002
- Messages
- 206
I need a formula that breaks one cell down into three cells. On 3-13 I received a reply to a post that gave me the following.
cell I, = K L M
15.0 = 8.0, 4.0, 3.0
8.5 = 8.0, 0.5, False
8.0 = 8.0, Blank, False
0.0 = 0.0, Blank, False
What im looking for is is to break down cell I,into K, L,& M, as follows:
cell I K, L, M
15.0 = 8.0, 4.0, 3.0
8.5 = 8.0, 0.5, 0.0
8.0 = 8.0, 0.0, 0.0,(Or 0 = BLANK)
0.0 = 0.0, 0.0, 0.0
This is used to track time into deferent pay scales I = Total hours into, K = Reg.hours, L = Over time and M = Double time.
HELPPPPPP! MY 5LB HAMMER IS ABOUT YO DO COMPUTER VIOLANCE, TRYING TO FIGURE THIS ONE OUT. BOB.
This message was edited by cblincoln43 on 2002-03-15 11:22
This message was edited by cblincoln43 on 2002-03-15 11:27
cell I, = K L M
15.0 = 8.0, 4.0, 3.0
8.5 = 8.0, 0.5, False
8.0 = 8.0, Blank, False
0.0 = 0.0, Blank, False
What im looking for is is to break down cell I,into K, L,& M, as follows:
cell I K, L, M
15.0 = 8.0, 4.0, 3.0
8.5 = 8.0, 0.5, 0.0
8.0 = 8.0, 0.0, 0.0,(Or 0 = BLANK)
0.0 = 0.0, 0.0, 0.0
This is used to track time into deferent pay scales I = Total hours into, K = Reg.hours, L = Over time and M = Double time.
HELPPPPPP! MY 5LB HAMMER IS ABOUT YO DO COMPUTER VIOLANCE, TRYING TO FIGURE THIS ONE OUT. BOB.
This message was edited by cblincoln43 on 2002-03-15 11:22
This message was edited by cblincoln43 on 2002-03-15 11:27