View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
matfis matfis is offline
external usenet poster
 
Posts: 1
Default 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