User Manual

10.03.2024

MANUAL

Formula (Extended): $MINUTE Function

## Overview Finds the number of minutes in a specified date. ## Syntax ``` $MINUTE(Date) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Date|Date or date string in yyyy/mm/dd or yyyy/mm/dd hh:MM:ss format|Required|Auto-completes to "00:00:00" in yyyy/mm/dd format. | ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Date|Yes|No|Yes|Yes|No| ## Return Value Minutes (0 to 59). ### Return Value Display Content |Target|Display Content of Return Value| |:---|:---| |Classification (including title, status, manager, owner)|Display return value. In the case of a drop-down list with values, the options that match the return value are displayed. | |Numerical Value (including work volume, progression rate, remaining work volume)|Display return value. | |Date (including start and completion)|Do not display. | |Description (including content)|Display return value. | |Check (including lock)|Do not display. | ## Usage Example ① Specify parameters by screen column name (name displayed) ### Formula ![image](https://pleasanter.org/binaries/4ab1aad17ff049b39f9028c2af54c8d1) ### Parameters ![image](https://pleasanter.org/binaries/5e1aa3ad61f14981a3641b81bc42a37d) ### Calculation Result ![image](https://pleasanter.org/binaries/9eabfe5b6d624b81bfe3a4df63a692fe)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.