How to Install the Excel 2007 Analysis ToolPak
Switching Vertical and Horizontal Data with Excel 2007's TRANSPOSE Function
Simplifying Numbers with Excel 2007's INT and TRUNC Functions

Deconstructing Time with Excel 2007's HOUR, MINUTE, and SECOND Functions

Excel 2007 includes several time functions that you can use in your worksheets. Use the HOUR, MINUTE, and SECOND time functions to extract the hours, minutes, and seconds from a single time serial number.

The HOUR, MINUTE, and SECOND functions let you extract specific parts of a time value in the worksheet. Each of these three time functions takes a single serial_number argument that contains the hour, minute, or second that you want to extract.

So, for example, if cell B5 contains the time 1:30:10 p.m. (otherwise known as serial number 0.5626157) and you enter the following HOUR function in cell C5:

=HOUR(B5)

Excel returns 13 as the hour to cell C5 (hours are always returned in 24-hour time). If you then enter the following MINUTE function in cell D5:

=MINUTE(B5)

Excel returns 30 as the number of minutes to cell D5. Finally, if you enter the following SECOND function in cell E5:

=SECOND(B5)

Excel returns 10 as the number of seconds to cell E5.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Calculating Loan Payments with Excel 2007's PMT Function
Powers and Roots in Excel 2007: The POWER and SQRT Functions
Deconstructing Dates in Excel 2007 with DAY, WEEKDAY, MONTH, and YEAR
Crunching Numbers with Excel 2007's AVERAGE, MAX, MIN, and MEDIAN Functions
Excel 2007 Database Functions
Advertisement

Inside Dummies.com