Make sure the formatting on the HHMM column in Excel is "General".
Next, is the time field coming across as Text or as a Value? A1 B1 C1 D1 145 0145 01:45 01:45 For instance, if it is importing as a number like Cell A1, then the formula in C1 would be: =VALUE(LEFT(TEXT(A1,"0000"),2)&":"&RIGHT(TEXT(A1,"0000"),2)) Or, if it is importing as text like in Cell B1, then the formula is D1 would be: =VALUE(LEFT(B1,2)&":"&RIGHT(B1,2)) Hope this is what you were wanting. Chase Rodgers Financial Reporting Manager Medical Center of Plano *214-473-7490 [EMAIL PROTECTED] ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitchell Sherry - Mid West Div. Sent: Tuesday, August 05, 2008 01: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
