You don't say exactly what your cell entry contains, but this might work
for you. Assuming your time values are in column A, in column B enter
this formula:

=TIMEVALUE(LEFT(A1,LEN(A1)-xx)) where 'xx' is the number of extraneous
characters you have after the actual time entry. e.g. if your cell
contains "10:24 pm PST" then xx would be 4. The formula would return
10:24 PM in the time format set for the cell in col B.

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=389157