• 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 Enter Excel "Sees"
10/15/01 35717
6/30/61 21000
2:45 PM 0.61458333
10:02:56 AM 0.4187037
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