HOUR ()
The function
will show the hour of the day based upon a time or a number.
Best view in desktop mode.
|
|
A
|
B
|
C
|
D
|
|
1
|
Number
|
Hour
|
||
|
2
|
9:15 PM
|
21
|
=HOUR(A2)
|
|
|
3
|
0.25
|
6
|
=HOUR(A3)
|
|
|
4
|
2/19/2020 23:46
|
23
|
=HOUR(A4)
|
|
|
5
|
Syntax
=HOUR(serial_number)
Formatting
The result will
be shown as a normal number between 0 and 23.
No comments:
Post a Comment