Changing h:mm AM/PM to hhmmss Solved/Closed

Question

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

Trowa · Answer

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

Changing h:mm AM/PM to hhmmss

1 response

Similar discussions

Subscribe To Our Newsletter!