shumonsaha
Board Regular
- Joined
- Mar 22, 2009
- Messages
- 56
Hi.
I need help on the following. I cannot write VB code and use the record macro option or excel formulas for my work. so it becomes more of a challenge.
Col A has different values like Program names - A, B,C, D,E, Etc
Col B has the time for the programs
So, program with name A in the column A will have time showing as 18:30, 18:25, 18:22, 18:28, 18: 29 etc.
Similarly program B starts at time close to 20:00, 20:05, 20:08 etc
I want to insert a col C with mconcat formula so that Program A to show only 18:30 (rounded) , Program B rounde close to 20:00 etc
any suggestions?
I need help on the following. I cannot write VB code and use the record macro option or excel formulas for my work. so it becomes more of a challenge.
Col A has different values like Program names - A, B,C, D,E, Etc
Col B has the time for the programs
So, program with name A in the column A will have time showing as 18:30, 18:25, 18:22, 18:28, 18: 29 etc.
Similarly program B starts at time close to 20:00, 20:05, 20:08 etc
I want to insert a col C with mconcat formula so that Program A to show only 18:30 (rounded) , Program B rounde close to 20:00 etc
any suggestions?