TIME SHEETS

[YARNOS]

i WANT TO CREATE START AND FINISH TIME IN THE CELL BUT NOT IN A TYPE IN FORMAT A DROP DOWN MENU SELECTION WITH 15MIN INCREMENTS CAN ANYBODY HELP ME OUT THERE???? I DON'T HAVE MUCH EXPERIENCE IN DOING THESE TYPE OF FORMATS.... PLS HELP!!!!! ON HOW TO DO THIS..

 

[royUK]

Do you want a drop down list to choose e.g. 15 ;30;45 etc. If so create a list of these numbers and in the cell where you want your result choose Data>Validation>Allows>List and choose the range that contains your list(which can be hidden)
This message was edited by royUK on 2002-09-27 02:41

 

[YARNOS]

THANK YOU THATS AN EXCELLENT APPROACH BUT I WILL BE MORE SPECIFIC THIS TIME A MENU THAT DROPS DOWN WITH A CURSOR BESIDE IT WITH ALL THE TIME IN A DAY WITH 15MIN INCREMENTS
THANK YOU ROY.....

 

[Scorp1]

Hi, copy this to your list and you have 15 mins format the list as time

0:00
0:15
0:30
0:45
1:00
1:15
1:30
1:45
2:00
2:15
2:30
2:45
3:00
3:15
3:30
3:45
4:00
4:15
4:30
4:45
5:00
5:15
5:30
5:45
6:00
6:15
6:30
6:45
7:00
7:15
7:30
7:45
8:00
8:15
8:30
8:45
9:00
9:15
9:30
9:45
10:00
10:15
10:30
10:45
11:00
11:15
11:30
11:45
12:00
12:15
12:30
12:45
13:00
13:15
13:30
13:45
14:00
14:15
14:30
14:45
15:00
15:15
15:30
15:45
16:00
16:15
16:30
16:45
17:00
17:15
17:30
17:45
18:00
18:15
18:30
18:45
19:00
19:15
19:30
19:45
20:00
20:15
20:30
20:45
21:00
21:15
21:30
21:45
22:00
22:15
22:30
22:45
23:00
23:15
23:30
23:45

 

[YARNOS]

CAN YOU PLS EXPLAIN THIS IN MORE DETAIL IN ORDER TO CREATE THIS!!!!!
How will you create the drop down menu with the scroll down cursor showing so then you can use the mouse to select the specific time....

 

[royUK]

Hi
Create your list as Scorp suggests in a column. Choose the cell that you want to put your result and open the Data Menu from the Toolbar. Pick Validation, you will get a form and choose from the dropdown list pick from "list", there is a box to enter the range containing your list. click in it and go to the first cell in your list and drag down to highlight all numbers. Now when you click on the results cell you will get a drop down list with your numbers in

 

[Scorp1]

Hi,

ok you can put the list on a sheet you don’t use i.e. last sheet in the workbook( copy the list above), once you have pasted the list on the last page go to the cell you want the data to be (once you have chosen it leave it selected) now go to Data, then Validation, then choose List from the Allow drop down. Next click the source and high light your list that you put on the last page, click ok.

If you go to the cell you get a drop down arrow click it and a list appears chose a time and that’s it .

There are a few other methods using combo or list boxes but these are a little more involved using Index function

hope that helps

 

[YARNOS]

THANK YOU FELLAS FOR SUPPORT I ACHIEVED WHAT I WAS AFTER...ITS GREAT...>>>