O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15. Formatting and Calculating Date and Time

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.

Understanding How Excel Records Dates and Times

Excel assigns serial values to days, hours, minutes, and seconds, which makes it possible for you to perform ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required