Convert Text to time value

H

Hillheader

Hi

I have a text value HH:MM:SS a/p.m. (eg 7:02:43 a.m. or 12:18:18 p.m.
and I need to convert this to a HH:MM:SS value in the 24 hour format t
allow easier sorting.

Can anyone help with the syntax please?

Cheer
 
D

Dave O

With your sample time in cell A1, I got this formula to generate
something appropriate:
=TEXT(HOUR(A1),"00")&TEXT(MINUTE(A1),"00")

....where the time in A1 is an Excel-readable time format. Does that
get you close?
 
H

Hillheader

Dave

Thanks for taking the time to reply.

In searching further I actually found an even quicker way. If I simpl
replace the "a.m." with "AM" and the "p.m." with "PM" it changes th
structure of the cell so that formatting the column now does th
convertion for me.

Again thanks for the reply. Much appreciate
 
Top