Accommodate inconsistent time format inputs

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.

you can try this (24-hour)

dv-time.jpg

and custom format to: hh:mm