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.
In this tutorial:
- Date and Time Formulas in Excel
- Constructing Date and Time Formulas
- Building Formulas that Calculate Dates and Times
- Working with Simple Date Functions
- TODAY, NOW, DATE, and DATEVALUE Date Functions
- Working with Excel's More Date Functions
- WEEKDAY, WEEKNUM, and YEARFRAC Date Functions
- Working with the Time Functions
- Building Formulas with Common Time Functions
More from MS-Excel