I am designing a sheet to act as a form (not a Userform).
The form then updates a database sheet via a macro.
One of the fields is a time window for delivery.
The upper and lower bounds are in different cells.
One of the issues i foresee is different users inputting times in different formats.
i.e. 13:30, 1:30 pm 1:30pm 13.30 1330 etc.
It there a way I can accommodated these inputs such that the database is consistent.
Thanks in advance.
Bookmarks