Microsoft Office Tutorials and References
In Depth Information
Deconstructing Time with HOUR, MINUTE, and SECOND
Isolating the hour
Extracting the hour from a time is useful in applications that tally hourly
events. A common use of this occurs in call centers. If you’ve ever responded
to an infomercial or a pledge drive, you may realize that a group of workers
wait for incoming phone calls such as the one you made (I hope you got a
good bargain). A common metric in this type of business is the number of
calls per hour.
Figure 13-3 shows a worksheet that summarizes calls per hour. Calls have
been tracked for October 2012. The incoming call dates and times are listed
in Column A. In Column B, the hour of each call has been isolated with the
HOUR function. Column D is a summary of calls per hour, over the course
of the month.
Figure 13-3:
Using the
HOUR
function to
summarize
results.
In Figure 13-3 the values in Column D are calculated using the COUNTIF
function. There is a COUNTIF for each hour from 10 a.m. through 11 p.m. Each
COUNTIF looks at the range of numbers in Column B (the hours) and counts
the values that match the criteria. Each COUNTIF uses a different hour value
for its criteria. The following is an example:
=COUNTIF($B$3:$B$1100,”=16”)
Here is how to use the HOUR function:
1. Select the cell where you want the result displayed.
2. Enter =HOUR( to begin the function entry.
Search JabSto ::




Custom Search