:Date and time functions: Use the HOUR function to calculate the hourly time difference-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Date and time functions: Use the HOUR function to calculate the hourly time difference

Date and time functions: Use the HOUR function to calculate the hourly time difference

Author: daogeziyuan • • Table skills • Views 798
  • Picture and text skills
  • Case

Returns the hour of the time value. That is an integer between 0 (12:00 A.M.) and 23 (11:00 P.M.).


Syntax
HOUR(serial_number)
Serial_number represents a time value that contains the hour you are looking for.

Times can be entered in several ways: as a quoted text string (for example: 6:45 PM), as a decimal number (for example, 0.78125 for 6:45 PM), or as a decimal number

The result of another formula or function (for example: TIMEVALUE(6:45 PM)).

Description
WPSThe time value of the table is part of the date value. And expressed as a decimal number (for example, 12:00PM can be expressed as 0.5, because it is half of the day).

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/ri-qi-he-shi-jian-han-shu-qiao-yong-HOUR-han-shu-ji-suan-xiao-shi-shi-cha.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 任斌设计二快印 Columnist
48 196
single-end

Related Suggestion