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.
Here the number format selection. It allows you to select
accurately in which format you want to have your time formatted.
If you are not happy with the selection, you can type your
own based on the following rules (mm:ss, hh:mm:ss, ...)
Now you try....