I have cells in Excel that are formatted as '1:30 PM', and I want to know how to convert: (1) '6:00 AM' to '0600'; and (2) '8:00 PM' to '2000'?
I've spent a lot of time trying to figure this out, but I don't know how to add a '0' before the 600, nor do I know how to get rid of the colon. Thank you for your help.
Bookmarks