COL A COL B
1 17:30
2 17:45
3 17:00 17:30
4 17:44 17:23
5 17:11 17:34
6 17:13
Given the above cells of time data, i need a formula that will search a1:b20 and give me a count of time values, in this case the answer is 6, keeping in mind that a1 and a2 may or may not be blank. In other words, the first value in either col. A or B should be the first value counted, and the last value in either col. A or B should be counted, and the values in-between. I hope this makes sense....please help. thanks
Eddie G
1 17:30
2 17:45
3 17:00 17:30
4 17:44 17:23
5 17:11 17:34
6 17:13
Given the above cells of time data, i need a formula that will search a1:b20 and give me a count of time values, in this case the answer is 6, keeping in mind that a1 and a2 may or may not be blank. In other words, the first value in either col. A or B should be the first value counted, and the last value in either col. A or B should be counted, and the values in-between. I hope this makes sense....please help. thanks
Eddie G