I would like to add 1 hour to these cells in column A:A (varied length daily)
I have sample data as follows
Vba would be good but i will be happy with any solution as I have a headache from trying to get a solution
12:30 Staw (AUS) Place
12:35 Cona (AUS) Place
12:50 Lism (AUS) Place
13:00 Staw (AUS) Place
13:10 Cona (AUS) Place
13:25 Lism (AUS) Place
13:30 Staw (AUS) Place
13:45 Cona (AUS) Place
14:00 Staw (AUS) Place
14:05 Lism (AUS) Place
14:25 Cona (AUS) Place
Where it is 12:30 Staw (AUS) Place
it should read 13:30 Staw (AUS) Place
any help will again be appreciated
Graham
Bookmarks