Microsoft Office Tutorials and References
In Depth Information
Deconstructing Time with HOUR, MINUTE, and SECOND
3. Click the cell that has the full-time (or date/time) entry.
4. Enter a ), and press Enter.
Excel returns a number between 0 and 23.
Isolating the minute
Isolating the minute part of a time is necessary in applications that track
activity down to the minute. A timed test is a perfect example. Remember in
school when the teacher would yell, “Pencils down”?
Excel can easily calculate how long something takes by subtracting one time
from another. In the case of a test, the MINUTE function helps with the
calculation because how long something took in minutes is being figured out.
Figure 13-4 shows a list of times it took for students to take a test. All
students started the test at 10 a.m. Then, when each student finished, the time
was noted. The test should have taken a student no more than 15 minutes.
For each data row, Column D contains a formula that subtracts the minute
in the end time, in Column C, from the start time, in Column B. This math
operation is embedded in an IF statement. If the result is 15 or less, then Yes
appears in column D; otherwise a No appears:
Like the HOUR function, the MINUTE function takes a single time or date/time
reference as its argument.