hello,
Hoping someone may be able to help.I download from a site data which has times in the format as per sample sheet col A.I would like to be able to automatically change it to 24 hour time as per col B.They do not put am or pm next to it.This I imagine would only create a problem if there were, for example morning times 10:30am and evening times 10:30pm without having am or pm.However in my case the earliest times at this stage appear to be
Starting in the morning 10:30am with the
latest start 10:00pm at night
So I would like up until 1pm to remain the same as in ColA e.g 10:30,11:45 then when it becomes 1:00 to change to 24 hour becoming 13:00.The 10PM at night would be then 22:00.
Bookmarks