Microsoft Office Tutorials and References
In Depth Information
HOUR
HOU HOUR returns the hour as a serial number integer between 0 and 23.
=HOUR(serial_number)
The HOUR function returns the hour serial number between 0 and 23. Notice the example in
Figure 4.5, the actual time is shown under the heading Actual Time and the HOUR function
extracts the serial number between 0 and 23. The formula can be used with cell reference or
with the serial number enclosed in parenthesis, as shown in the second example.
The serial number is a number between 0 and 23 that
represents a time of day. The serial number can be extracted
from text in quotes or as a cell reference.
SERIAL NUMBER
Figure 4.5
The HOUR function
returns the hour of the
day between 0 and 23.
1
Hour
B
Time of day
MINUTE
MINUTE returns the serial number that corresponds to the minute.
=MINUTE(serial_number)
The MINUTE function returns the value corresponding to a minute within an hour. For example,
if you have a time of 5:30 in the MINUTE function as shown, =MINUTE(“5:30 am”) , the return
result would equal 30.
The serial number is a number between 0 and 59 that
represents a time of day. The serial number can be extracted
from text in quotes or as a cell reference.
SERIAL NUMBER
Search JabSto ::




Custom Search