Hello people of talent and knowledge. I hope one of you can help.
I have a sheet, into column N of which, I will be pasting a ‘time’. As pasting continues down the column, the time will vary, increasing or decreasing but only by the full hour. It will be formatted as “09:00” for example.
I would like each cell in column M to take the time in the related cell in column N (i.e. M2 to ‘see’ N2) return it, add 1 hour to it and return the time formatted as “09:00 – 10:00”.