HOUR
ๅณๅๆๅฎๆ้ๅผ็ๅฐๆใ ๅฐๆๆไปฅ 0 ๅ 23 ไน้็ๆดๆธๅณๅใ
่ชๆณ
HOUR(serial_number)
serial_number ๆฏไธๅไฝ็บๆ้ๅผ็ๅ้ฒไฝๆธๅญ๏ผๆบ่ชๅฐๆๆธ่จ็ฎใ
็ฏไพ
=HOUR(NOW()) ๅณๅ็ฎๅ็ๅฐๆ
่ฅ C4 ็ๅ งๅฎน = 17:20:00๏ผๅ =HOUR(C4) ๆๅณๅ 17ใ