Hi
I have a long list of data of Columns A to C. What I would like to do is to have a VBA that would shift cell to the right if value on column A is time (stay as is if percentage). My desired outcome is column E to G but I would want in column A to C.
I have a long list of data of Columns A to C. What I would like to do is to have a VBA that would shift cell to the right if value on column A is time (stay as is if percentage). My desired outcome is column E to G but I would want in column A to C.
Book3 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | ||||||||||
2 | 5.94% | 2:50 | 4/28/2022, 4:45:12 PM | 5.94% | 2:50 | 4/28/2022, 4:45:12 PM | ||||
3 | 46.13% | 2:47 | 4/28/2022, 4:49:12 PM | 46.13% | 2:47 | 4/28/2022, 4:49:12 PM | ||||
4 | 0:45 | 4/28/2022, 4:44:12 PM | 0:45 | 4/28/2022, 4:44:12 PM | ||||||
5 | 8:08 | 4/28/2022, 4:43:58 PM | 8:08 | 4/28/2022, 4:43:58 PM | ||||||
Sheet1 |