• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Entering Dates and Times

Although it's true that the serial numbers make it easier for the computer to manipulate dates and times, it's not the best format for humans to comprehend. For example, the number 25,404.95555 is meaningless, but the moment it represents (July 20, 1969, at 10:56 p.m. EDT) is one of the great moments in history (the Apollo 11 moon landing). Fortunately, Excel takes care of the conversion between these formats so that you never have to worry about it. To enter a date or time, use any of the formats outlined in Table 10.3.

Table 10.3. Excel Date and Time Formats
FormatExample
m/d/yyyy8/23/2004
d-mmm-yy23-Aug-04
d-mmm23-Aug (Excel assumes the current year)
mmm-yyAug-04 (Excel assumes the first day of the month)
h:mm:ss AM/PM10:35:10 PM
h:mm AM/PM10:35 PM
h:mm:ss22:35:10
h:mm22:35
m/d/y h:mm8/23/04 22:35



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint