Convert Text to time value
 

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 to
allow easier sorting.

Can anyone help with the syntax please?

Cheers


--
Hillheader
------------------------------------------------------------------------
Hillheader's Profile: http://www.excelforum.com/member.php...o&userid=30644
View this thread: http://www.excelforum.com/showthread...hreadid=518384

Convert Text to time value
 

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?

Convert Text to time value
 

Dave

Thanks for taking the time to reply.

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

Again thanks for the reply. Much appreciated


--
Hillheader
------------------------------------------------------------------------
Hillheader's Profile: http://www.excelforum.com/member.php...o&userid=30644
View this thread: http://www.excelforum.com/showthread...hreadid=518384