software

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: www.excelforum.com/member.php...oamp;userid=30644
View this thread: www.excelforum.com/showthread...hreadid=518384With your sample time in cell A1, I got this formula to generate
something appropriate:
=TEXT(HOUR(A1),quot;00quot;)amp;TEXT(MINUTE(A1),quot;00quot;)

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

Thanks for taking the time to reply.

In searching further I actually found an even quicker way. If I simply
replace the quot;a.m.quot; with quot;AMquot; and the quot;p.m.quot; with quot;PMquot; 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: www.excelforum.com/member.php...oamp;userid=30644
View this thread: www.excelforum.com/showthread...hreadid=518384