MS-Excel / Functions and Formula

Working with the Time Functions

Excel's Time functions are a smaller subset of the Date functions.
They include the NOW function, which returns the current date and time; TIME, which creates a time fraction from values representing the hour, minutes, and seconds; and TIMEVALUE, which converts a time entered or imported into the worksheet as text so that you can use it in formulas that calculate elapsed times.

Following section:
Building Formulas with Common Time Functions

[Previous] [Contents] [Next]

In this tutorial:

  1. Date and Time Formulas in Excel
  2. Constructing Date and Time Formulas
  3. Building Formulas that Calculate Dates and Times
  4. Working with Simple Date Functions
  5. TODAY, NOW, DATE, and DATEVALUE Date Functions
  6. Working with Excel's More Date Functions
  7. WEEKDAY, WEEKNUM, and YEARFRAC Date Functions
  8. Working with the Time Functions
  9. Building Formulas with Common Time Functions