Working with Date and Time Functions
Using the Excel date and time functions, you can perform worksheet calculations quickly and accurately. For example, if you use your worksheet to calculate your company’s monthly payroll, you might use the HOUR function to determine the number of hours worked each day and the WEEKDAY function to determine whether employees should be paid at the standard rate (for Monday through Friday) or at the overtime rate (for Saturdays and Sundays).
In the following sections, we’ll explore a few of the most useful date and time functions in detail. You can access all 20 of the date and time functions available in Excel by clicking the Date & Time button on the Formulas tab on the Ribbon. For complete information about all ...
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.
