I have a worksheet that contains a list of time values in 12hr clock format, (e.g., 02:30 PM). that i need to convert in to 24hr clock format, (e.g., 14:30). No matter what i do, Excel always seems to regard the 12hr clock format as text.
Does anyone know a simple way to convert?

Thanks
Stu