Abstract
Transcript
In this lesson we’ll look at the Time format.
Like the Date format, the Time format includes a number of built-in options for displaying time.
Let’s take a look.
Here we have a set of times in column B of our table.
The asterisk means that this time format is controlled by the regional configs on the computer.
This means that this time format may look different on different computers, depending on regional options.
We can set time to display in military formatwithout the AM or PMwith and without seconds.
We can also use Format Cells to show a standard AM/PM time with and without seconds.
Finally, we have the option to select a time format that includes a date.
