LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Help with a Dropdown List of Times

Hi all! Am trying to set up the following and hope that I can get some help
from here.

I am currently trying to create a work rota and want to have the have both
the start and the finish times (every 15 mins over a 24 hr period) to appear
as lists and once selected, it calculate what time has been worked.

This I think I have done, but on both the start and finish times, currently
the same list of times appears.

What I would ideally like to happen though is once a 'Start Time' has been
selected, then only times after that selected, appear as a list in the
'Finish Time' box. Or visa versa - once a 'Finish Time' has been selected,
only times before that are displayed in the 'Start Time' as a list.

All assistance would be grately appreciated.

Thanks in advance
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DROPDOWN LIST OF TIMES nando Excel Discussion (Misc queries) 6 April 4th 23 02:31 PM
dropdown list determined by another dropdown list Wackyracer Excel Discussion (Misc queries) 5 April 27th 09 10:49 PM
Dropdown List - list item endings not visible if column too narrow AK9955 Excel Discussion (Misc queries) 2 April 27th 07 09:02 AM
result of selecting from the dropdown list should be a dropdown list No News Excel Worksheet Functions 0 July 5th 06 04:09 PM
result of selecting from the dropdown list should be a dropdown list No News Excel Worksheet Functions 2 July 1st 06 10:53 AM


All times are GMT +1. The time now is 09:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"