反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

HOUR

  • Recent Updates: April 04, 2022

    • 1. Extracted data

    1）Overview

    SyntaxHOUR(serial_number,format)Returns the number of hours at a specified time. The function specifies HOUR as an integer between 0 (0:00) and 23 (23:00).
    Parameterserial_number

    That includes the hours you want.

    2）Precautions

    • The HOUR(serial_number) parameter is allowed to be empty. If the parameter is empty, the value is the number of hours corresponding to the current system server time.

    • The first parameter default date or text type, the second default parameter text.

    3）Example

    FormulaResultRemark
    HOUR("11:32:40")11
    HOUR()15The corresponding system server time is 2020-10-23 15:36:2
    HOUR("11:32:40","HH:mm:ss")11

    2. Real-time data

    1）Overview

    SyntaxHOUR(serial_number)Returns the number of hours at a specified time. The function specifies HOUR as an integer between 0 (0:00) and 23 (23:00).
    Parameterserial_number

    That includes the hours you want.

    2）Precautions

    • The HOUR(serial_number) parameter is allowed to be empty. If the parameter is empty, the value is the number of hours corresponding to the current system server time.

    • You can use the default date, or a text-type parameter.

    3）Example

    FormulaResultRemark
    HOUR("11:32:40")11
    HOUR()15The corresponding system server time is 2020-10-23 15:36:2


    Attachment List


    Theme： Advanced Data Analyis
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ：800049425

    热线电话：400-811-8890转2

    总裁办24H投诉

    热线电话：173-1278-1526

    文 档反 馈

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭