TIME and HOURS Formatting in Excel

Want to display todays time or display a date in a different format. Here I show you. For Date formatting go to Date Formatting

Display time in a different format, like 13:05:25 or 1:05PM or 45:45:45.... the format choice is yours.

This is done with the properties of the cell and selecting the Time format like here or MORE NUMBER FORMATS on the bottom.

time formating



Here the number format selection. It allows you to select accurately in which format you want to have your time formatted.

format time

If you are not happy with the selection, you can type your own based on the following rules (mm:ss, hh:mm:ss, ...)

number formats

Now you try....