Entering a time

You can enter times and format them to display in a variety of ways. Building your worksheet provides basic information about entering and editing data.

  1. Click the cell where you want to enter the time.

  2. Type the time in one of the following formats:

  3. Press ENTER.

Note Times between 12 AM (midnight, 00:00:00) and one second before midnight (23:59:59) are valid times. Invalid times, such as a time greater than 23:59:59, display as 00:00 or 12:00 AM. If you enter a time other than 00:00 or 12:00 AM and it displays as 00:00 or 12:00 AM, you have entered an invalid time.



Formatting times

You can enter a time and then change the format to display it a different way. Changing the format changes how the time is displayed, but does not change how the time number is stored or used in calculations. Why do I need different number formats? and Formatting numbers as times give you more information about changing the time format.



See also
Selecting and deselecting data
Entering a number
Entering text
Entering a date
Editing data