Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation
How can I restrict entry to ceels between the times of
18:00 & 06:00, this must allow 22:00 etc This is so it covers the night shift in 24hr format Pete |
#2
|
|||
|
|||
Select the cells
Choose DataValidation From the Allow dropdown, choose Custom In the Formula box, type a formula that refers to the active cell, e.g.: =OR(B5=0.75,B5<=0.25) Click OK Pete wrote: How can I restrict entry to ceels between the times of 18:00 & 06:00, this must allow 22:00 etc This is so it covers the night shift in 24hr format Pete -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
One way is to add 6 hours to what's in the cell and then check that to see if
it's still less than noon. =MOD((A1+TIME(6,0,0)),1)<TIME(12,0,0) (maybe "<=" instead of "<") Pete wrote: How can I restrict entry to ceels between the times of 18:00 & 06:00, this must allow 22:00 etc This is so it covers the night shift in 24hr format Pete -- Dave Peterson |
#4
|
|||
|
|||
Try this:
Say times to be entered in Column E Select E1:E10, then, <Data <Validation, In "Allow" window, check "custom", In Formula box, enter: =OR(E1=TIME(18,,),E1<=TIME(6,,)) Then <OK. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Pete" wrote in message ... How can I restrict entry to ceels between the times of 18:00 & 06:00, this must allow 22:00 etc This is so it covers the night shift in 24hr format Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |