Previous Topic Next Topic

Changing h:mm AM/PM to hhmmss

Solved/Closed
icooper - Mar 9, 2010 at 03:24 PM
 Trowa - Mar 11, 2010 at 08:20 AM
Hello,

I need help changing imported times from i.e. 2:38 PM to 143800 (hhmmss).
Please Help!!

Thanks,
icooper

1 response

Answer 1 / 1
Trowa
Mar 11, 2010 at 08:20 AM
Hi Icooper,

Select your cell and press Ctrl+1 to open the cellproperties window. Go to the left most tab called "number" and select the bottom most option, I believe it's called custom. In the field "Type:" enter hhmmss, click OK and you are set.

Best regards,
Trowa