New user with a question

[earljoe]

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?

[Anne Troy]

Use Data Validation (and perhaps place your list on another worksheet):
http://www.officearticles.com/excel/...**********Hope it helps!Anne Troywww.OfficeArticles.com"earljoe" <[email protected]> wrote inmessage news:[email protected]...>> 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>

[[email protected]]

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