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

or can I?

"Gord Dibben" wrote:

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 DataValidationList 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


On Wed, 28 Jun 2006 15:50:01 -0700, nando
wrote:

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?