LIST TIMES

[ml0824]

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

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[ml0824]

Office 365 looking for the version, Windows TY

 

[Fluff]

Thanks for that, how about

+Fluff 1.xlsm
	A	B
1
2		18:00:00
3		18:30:00
4		19:00:00
5		19:30:00
6		20:00:00
7		20:30:00
8		21:00:00
9		21:30:00
10		22:00:00
11		22:30:00
12		23:00:00
13		23:30:00
14		00:00:00
15		00:30:00
16		01:00:00
17		01:30:00
18		02:00:00
19
Lists

Cell Formulas
Range	Formula
B3:B18	B3	=SEQUENCE(16,,B2+1/48,1/48)
Dynamic array formulas.

 

[ml0824]

Thank you!!! Never heard of sequence.

 

[Fluff]

You're welcome & thanks for the feedback.