Re: 24hr Time format
- Select the time.
- Press CTRL + 1.
- Select Custom.
- Select h:mm.
- Click OK.
How to do time format in Excel?
On the Home tab, in the Number group, click the Dialog Box Launcher next to Number. You can also press CTRL+1 to open the Format Cells dialog box. In the Category list, click Date or Time. In the Type list, click the date or time format that you want to use.
How do I format time in Excel without AM or PM?
Adjust Number Formats
In the Home Tab, Numbers group, press the More button at the lower right. This time, you want the number format to be simply h:mm. So no AM/PM necessary.