I have a database dump in excel that has a field with date and time in the format 2/27/11 13:21. I am looking for a formula that will just give me the time. In this example 13:21. I am trying to determine if the record was created before or after 5 PM each day.
Any ideas are appreciated.