Hey,
I have some logs from TV stations, and some come in AM/PM time format, but I need it in 24 hour format to upload to the database (HHMM). I tried going to format and doing a special format to type in HHMM, but that doesn't convert to 24 hour, it just drops the AM/PM.
Thanks!
Last edited by RussellNonBrand; 01-26-2011 at 03:01 PM.
Try [hh]mm
Does that work?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Forgot to mention this before... but that seems to add 12 hours... i.e. 1pm turned into 2500.
Slight correction to ChemistB's suggestion:
put a : (colon) after the [hh]
Hmmmm, that implies that a hidden date is being imported also. How are you importing data? Can you upload a small sample of your data in Excel? Include that one that reformats to 2500.
That's really weird. I just opened the exact same log, and this time it is formatting correctly. Oh well, problem solved! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks