Forum Discussion
24hr Time format
Hi, I need to turn 12hr time formatting that's aligned to the left and format it to 24hr time and align it to the right. How can I do this without having to click into each cell. For example: 4:36...
Thank you for your help. Unfortunately, this way isn't working for me either. I keep testing it out though. I did do this process in the beginning.
Interesting, I thought that military time format for 4:36 PM will be 1636.
Anyway, if you'd like to convert to 16:36 PM and keep time value
(I guess you converted to text "16:36 PM" as in the second cell), you may apply to all cells with time custom number format
[<0.5]hh:mm "AM";[>0.4999999999]hh:mm "PM"as in the third cell. Please check in attached file as well.
SergeiBaklan Thank you for your help. Everything has been figured out.
Kay_T1060 , glad to help