Try formatting the cell(s) to Text. Excel won't try to re-format it then. It's doubtful you will find a "format" that does not try to convert the number (counting up from 01/01/1900) to equal a time you want it to. (i.e.: 1408 = 11/8/1903 12:00:00 AM ) Google it and then you can write a macro to convert any cells with the Meditech HHMM format to a legit excel "time" format. Good luck.
Brian Bennett Affinity Health Systems Systems Analyst PBS\Clinic Billing (920)628-9055 [EMAIL PROTECTED] _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitchell Sherry - Mid West Div. Sent: Tuesday, August 05, 2008 1:28 PM To: [email protected] Subject: [Talk] Time Fields A co-worker downloaded an NPR report of OR Times. Meditech indicates that the field formats are HHMM. When I attempt to convert the field to a time format in Excel it takes the numbers and creates a date time field with the date from the digits and the time as 0. Has anyone come across this and figured out a fix? I'm having trouble trying to change them in a script as well ... HELP, Sherry HCA Midwest Health Systems IT&S Programmer/Analyst II 816/823-0406 "Some of us are more capable than others of us...but none of us is more capable than all of us" Tom Wilson/Ziggy
