New user with a question

E

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?
 
A

Anne Troy

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

hansyt

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
 
Top