I am creating a time sheet and I want to either creat a droplist but I
think I will have too many entries it has to be in 15 min increments
for the 24 hrs. I got it up to 10:45 am from midnight but it wont let
me make any more entries. Either that or I need a way that the ( : )
does not need to be entered to keep the formulas working correctly. Can
anyone help?


--
earljoe
------------------------------------------------------------------------
earljoe's Profile: http://www.excelforum.com/member.php...o&userid=31174
View this thread: http://www.excelforum.com/showthread...hreadid=508340

Use Data Validation (and perhaps place your list on another worksheet):
http://www.officearticles.com/excel/...**********Hope it helps!Anne Troywww.OfficeArticles.com"earljoe" wrote inmessage ... I am creating a time sheet and I want to either creat a droplist but I think I will have too many entries it has to be in 15 min increments for the 24 hrs. I got it up to 10:45 am from midnight but it wont let me make any more entries. Either that or I need a way that the ( : ) does not need to be entered to keep the formulas working correctly. Can anyone help? -- earljoe ------------------------------------------------------------------------ earljoe's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=31174 View this thread: http://www.excelforum.com/showthread.php?threadid=508340

To get a formatted time sheet:

Format Column A as time (hh:mm)
In A1 enter the increment as e.g. 00:15
In A2 enter the start time e.g. 00:00
In A3 enter: =A2+A1 and copy down to A97.
In B2 enter: =text(A2;"hh:mm") and copy down to B97.

Wha would you want to use a drop down for?

Hans