Hi,
I have range of dates in column A and times in rest of columna. Cell B5 is 00:00, I am looking for a VBA code to take the last value of row 5 and add 00:30 to it until 24 hours. i.e. C5 to be 00:30, D5 to be 01:00, E5 to be 01:30 and so on until AW5 to be 23:30.
Any help much appreciated.
Thanks,
Bookmarks