TIME SHEETS

YARNOS

New Member
Joined
Aug 26, 2002
Messages
21
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..
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

royUK

Well-known Member
Joined
Jul 24, 2002
Messages
1,606
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

New Member
Joined
Aug 26, 2002
Messages
21
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

New Member
Joined
Sep 24, 2002
Messages
7
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

New Member
Joined
Aug 26, 2002
Messages
21

ADVERTISEMENT

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

Well-known Member
Joined
Jul 24, 2002
Messages
1,606
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

New Member
Joined
Sep 24, 2002
Messages
7
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

New Member
Joined
Aug 26, 2002
Messages
21
THANK YOU FELLAS FOR SUPPORT I ACHIEVED WHAT I WAS AFTER...ITS GREAT...>>>
 

Forum statistics

Threads
1,144,510
Messages
5,724,777
Members
422,576
Latest member
kayth891

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top