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...
But what's the point?
4:36 PM = 16:36. There is no such time as 16:36 AM or 16:36 PM.
Alignment is done via Format, Cells... or via the buttons on the HOME ribbon.
Hi, I will need to put the times in military time to complete a report that I am doing. For some reason the times will not convert unless I click into each cell.
