Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DROPDOWN LIST OF TIMES | Excel Discussion (Misc queries) | |||
dropdown list determined by another dropdown list | Excel Discussion (Misc queries) | |||
Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions |