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.
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.
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.