# LIST TIMES

#### ml0824

##### New Member
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

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### Fluff

##### MrExcel MVP, Moderator
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

##### New Member
Office 365 looking for the version, Windows TY

#### Fluff

##### MrExcel MVP, Moderator
+Fluff 1.xlsm
AB
1
218:00:00
318:30:00
419:00:00
519:30:00
620:00:00
720:30:00
821:00:00
921:30:00
1022:00:00
1122:30:00
1223:00:00
1323:30:00
1400:00:00
1500:30:00
1601:00:00
1701:30:00
1802:00:00
19
Lists
Cell Formulas
RangeFormula
B3:B18B3=SEQUENCE(16,,B2+1/48,1/48)
Dynamic array formulas.

#### ml0824

##### New Member
Thank you!!! Never heard of sequence.

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

Replies
8
Views
241
Replies
1
Views
297
Replies
1
Views
223
Replies
3
Views
70
Replies
1
Views
306

1,147,733
Messages
5,742,859
Members
423,760
Latest member
photogfrog

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back