• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Using Functions in Formulas > Date and Time Functions

Date and Time Functions

Excel's date and time functions are designed specifically to work with dates and times. I tell you about the most useful ones here.

Table 1. Examples of how Excel Interprets Dates and Times
You EnterExcel “Sees”
10/15/02 36082
6/30/61 21000
2:45 PM 0.61458333
10:02:35 AM 0.41846065
1/1/1904 0
12:00 AM 0



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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