View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
keiko315 keiko315 is offline
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