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

Part 5: Creating Formulas and Performing... > Formatting and Calculating Date and ...

Chapter 15. Formatting and Calculating Date and Time

Understanding How Excel Records Dates and Times 435

Entering Dates and Times 436

Formatting Dates and Times 440

Calculating with Date and Time 444

Working with Date and Time Functions 445

You can use date and time values to date-stamp documents and to perform date and time arithmetic. Creating a production schedule or a monthly billing system is relatively easy with Microsoft Excel. Although Excel uses numeric values to count each nanosecond, starting from the beginning of the 20th century, you can use formatting to display those numbers in whatever form you want.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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