HOUR

ๅ‚ณๅ›žๆŒ‡ๅฎšๆ™‚้–“ๅ€ผ็š„ๅฐๆ™‚ใ€‚ ๅฐๆ™‚ๆœƒไปฅ 0 ๅ’Œ 23 ไน‹้–“็š„ๆ•ดๆ•ธๅ‚ณๅ›žใ€‚

่ชžๆณ•

HOUR(serial_number)

serial_number ๆ˜ฏไธ€ๅ€‹ไฝœ็‚บๆ™‚้–“ๅ€ผ็š„ๅ้€ฒไฝๆ•ธๅญ—๏ผŒๆบ่‡ชๅฐๆ™‚ๆ•ธ่จˆ็ฎ—ใ€‚

็ฏ„ไพ‹

=HOUR(NOW()) ๅ‚ณๅ›ž็›ฎๅ‰็š„ๅฐๆ™‚

่‹ฅ C4 ็š„ๅ…งๅฎน = 17:20:00๏ผŒๅ‰‡ =HOUR(C4) ๆœƒๅ‚ณๅ›ž 17ใ€‚

See also the following functions:

YEAR, NOW, MINUTE, MONTH, DAY, WEEKDAY