| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validate time entries linked to each other
Hi all,
Here is my problem: my staff has to enter over time per day. What would be the best way to validate those entries, ie: assuming that: A2, B2, C2 and D2 being respectively Start_am, End_am. Start_pm and End_pm? No entry is implemented as "-" (dash symbol). Type of validation: A2 < B2 and A2 < 9:00 and B2 < 13:00 and B2 < C2 < D2. tia. matfis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible to validate entries not to contain 00 | Excel Discussion (Misc queries) | |||
| How to validate entries with Data Forms in xls 2003? | Setting up and Configuration of Excel | |||
| How can i use a command button to validate date and time | Excel Discussion (Misc queries) | |||
| Time entries | Excel Worksheet Functions | |||
| How to validate data entries to be unique within an array | Excel Worksheet Functions | |||
Threaded Mode
