As with entering dates, you normally don’t have to worry about the actual time serial numbers. Just enter the time into a cell using a recognized format. Table 16-3 shows some examples of time formats that Excel recognizes.

TABLE 16-3
Time Entry Formats Recognized by Excel

11:30:00 am 11:30 AM
11:30:00 AM 11:30 AM
11:30 pm 11:30 PM
11:30 11:30 AM
13:30 1:30 PM

Because the preceding samples don’t have a specific day associated with them, Excel (by default) uses a date serial number of 0, which corresponds to the nonday January 0, 1900. Often, you’ll want to combine a date and time. Do so by using a recognized date-entry format, followed by a space, and then a recognized time-entry format. For example, if you enter 6/18/2007 11:30 in a cell, Excel interprets it as 11:30 AM on June 18, 2007. Its date/time serial number is 39251.4791666667.

When you enter a time that exceeds 24 hours, the associated date for the time increments accordingly. For example, if you enter 25:00:00 into a cell, it’s interpreted as 1:00 AM on January 1, 1900. The day part of the entry increments because the time exceeds 24 hours. Keep in mind that a time value without a date uses January 0, 1900 as the date.

Similarly, if you enter a date and a time (and the time exceeds 24 hours), the date that you entered is adjusted. If you enter 9/18/2007 25:00:00, for example, it’s interpreted as 9/19/2007 1:00:00 AM.

If you enter a time only (without an associated date), into an unformatted cell, the maximum time that you can enter into a cell is 9999:59:59 (just under 10,000 hours). Excel adds the appropriate number of days.

In this case, 9999:59:59 is interpreted as 3:59:59 PM on 02/19/1901. If you enter a time that exceeds 10,000 hours, the entry is interpreted as a text string rather than a time.

• The Golf Club at Terra Lago, Indio, CA The Golf Club at Terra Lago is located in: Indio, CA Phone: 760-775-2000 Website: http://golfclub-terralago.com About the Course: This is...
• Ventura Isle Marina, Channel Islands, CA Ventura Isle Marina is located in the Channel Islands, CA Phone: 805.644.5858 Average water depth: The marina did not report...
• My Journey’s July 16th 2009 Update One of the main reasons I started this site was to keep myself accountable to anyone that was reading. Ironic...
• My Prosper Internal Rate of Return Update (End of October 07) = (0.57)% This is a RateLadder only IRR update. (An IRR lender “game” update is in the works.) Here is my permanent...
• Pelican Scorpio Fishing Boat Delivery service will call to schedule appointment; delivery service includes the item dropped off at the curb at the end...