Try putting the desired time into a variable (var). Then use TIME(LEFT(var,2), RIGHT(var,2), 0)
Neal Quinn Montefiore Medical Center ----- Original Message ----- From: Mitchell Sherry - Mid West Div. To: [email protected] Sent: Tuesday, August 05, 2008 2:28 PM 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
