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.

Figure 13-4:

Calculating

minutes

elapsed

with the

MINUTE

function.

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:

=IF(MINUTE(C3)-MINUTE(B3)<=15,”Yes”,”No”)

Like the HOUR function, the MINUTE function takes a single time or date/time

reference as its argument.