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