Skip to content

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 Numeric 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.
Numeric 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

Formula using the $MINUTE function in usage example 1

Parameters

Parameters specified in usage example 1 of the $MINUTE function

Calculation Result

Calculation result of usage example 1 of the $MINUTE function