Sorry for the question, I'm sure it's simple but I can't figure it out and searched the threads.
All I want to do is create a list of times. I want to enter the time and calculate a half hour down each cell
If I enter 6:00PM (format in time) I want to automatically calculate the next 8 hours, every half hour
Ex 6:30 (FORMULA NEEDED)
7:00
7:30
8:00
8:30 etc...
I hope I'm explaining this correctly, the add formula does not seem to work with time. TIA
All I want to do is create a list of times. I want to enter the time and calculate a half hour down each cell
If I enter 6:00PM (format in time) I want to automatically calculate the next 8 hours, every half hour
Ex 6:30 (FORMULA NEEDED)
7:00
7:30
8:00
8:30 etc...
I hope I'm explaining this correctly, the add formula does not seem to work with time. TIA