Chapter 15. Formatting and Calculating Date and Time

You can use date and time values to stamp documents and to perform date and time arithmetic. Creating a production schedule or a monthly billing system is relatively easy with Microsoft Office Excel 2007. Although Office Excel 2007 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 ...

Get Microsoft® Office Excel® 2007 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.