Kay_T1060Copper ContributorFeb 12, 202024hr 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...Show More
Abiola1MVPFeb 12, 2020Kay_T1060 1. Select the time 2. Press CTRL + 1 3. Select Custom 4. Select h:mm 5. Click OK Once you clicked OK, the date will be 16:36 and right aligned as seen in the caption below
