On the Home tab, in the Cells group, click Format, and then click Format Cells. In the Format Cells dialog box, click the Number tab. Under Category, click Custom. In the Type box, type [h]:mm.
- How do I format HH MM SS in Excel?
- How do I format cells to display a time range instead of just the time?
How do I format HH MM SS in Excel?
Right click the selected cells and then click Format Cells, or press Ctrl + 1. This will open the Format Cells dialog box. On the Number tab, under Category, select Custom, and type one of the following time formats in the Type box: Over 24 hours: [h]:mm:ss or [h]:mm.
How do I format cells to display a time range instead of just the time?
Select the cell(s) that you want to format. Press Ctrl + 1 to open the Format Cells dialog. On the Number tab, select Time from the Category list, and then choose the desired format from the Type list. Click OK to apply the selected format and close the dialog box.