I have two columns that contain dates & times of phone calls. Some fields have the times entered in 24 format, while others have it entered in 12 hour format (with PM or AM).
I've formatted all of the cells to display the time as 24 hours, but I need the data normalized to be entered as 24 format. Is there a way to quickly do this, or am I stuck just retyping all the data?
Bookmarks