DROPDOWN LIST OF TIMES

N

nando

I would like to create a dropdown list containing all of the times throughout
the day. Do I have to enter each time seperated by commas (12:00 am,12:01
am,...) or is there an easier way?
 
G

Gord Dibben

In A1 enter the current day by hitting CTRL + ;(semi-colon)

Format column A as Custom h:mm AM/PM

In A2 enter =A1+1/1440

Drag/copy down column A.

Note there are 1440 minutes in a day.

Go to Data>Validation>List and enter the range A1:A1439 and OK

Are you sure you want a list with 1440 entries in it?


Gord Dibben MS Excel MVP
 
N

nando

That worked great now how do I get those times I created to dissapear without
damaging my list?

or can I?
 
G

Gord Dibben

You have to have the list somewhere on a sheet unless you want to type it
in.....NOT!!!!!!!!!

The easiest method is to place the list on another worksheet so's you don't see
it.

To do this, cut the column of times and paste to Sheet2.

Select A1:A1339 on Sheet2 and Insert>Name>Define.

Name it MyList or similar.

Go back to Sheet1 and select a cell.

Data>Validation>List>Source =MyList


Gord

That worked great now how do I get those times I created to dissapear without
damaging my list?

or can I?
Click to expand...

Gord Dibben MS Excel MVP
 
N

nando

Thanks man you're a gentleman and a scholar!!!

Gord Dibben said:
You have to have the list somewhere on a sheet unless you want to type it
in.....NOT!!!!!!!!!

The easiest method is to place the list on another worksheet so's you don't see
it.

To do this, cut the column of times and paste to Sheet2.

Select A1:A1339 on Sheet2 and Insert>Name>Define.

Name it MyList or similar.

Go back to Sheet1 and select a cell.

Data>Validation>List>Source =MyList


Gord



Gord Dibben MS Excel MVP
Click to expand...
 
Top