Name
HOUR
Synopsis
Use
HOUR to find out the hour portion of
a specific time. The function returns a value between
0
(12:00 midnight) and 23
(11:00 PM). For example, if the time is 3:45 PM, the HOUR function
will return a value of 15
. In other words, since
Excel deals with a 24-hour clock, HOUR returns the hour portion of
the time value based on a 24-hour clock.
To Calculate
=HOUR(Serial_Number
)
Example
HOUR is typically used to determine the hour value of a time in another cell. Figure 13-7 illustrates how you can get the hour value from a serial number in another cell.
Figure 13-7. You can use the different date and time functions to manipulate any value that can be interpreted as a date or time within your worksheet
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.