Spread Formula Reference
Formula Functions / Functions M to Q / MINUTE
In This Topic
    MINUTE
    In This Topic

    This function returns the minute corresponding to a specified time.

    Syntax

    MINUTE(time)

    Arguments

    Specify the time argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), a DateTime object, as in DATE(2003,7,4), or a TimeSpan object, as in TIME(12,0,0). For more details on the date and time inputs, refer to the discussion in Date and Time Functions

    Dates as numeric values are in the form x.y, where x is the "number of days since December 30, 1899" and y is the fraction of day. Numbers to the left represent the date. Times as numeric values are decimal fractions ranging from 0 to 0.99999999, representing the times from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.).

    Remarks

    The minute is returned as an integer, ranging from 0 to 59.

    Data Types

    Accepts numeric, string, DateTime object, or TimeSpan object data. Returns numeric data.

    Examples

    MINUTE(D1)

    MINUTE(R1C4)

    MINUTE(0.7) gives the result 48

    MINUTE("12:17") gives the result 17

    MINUTE(TIME(12,0,0))

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    HOUR | SECOND | Date and Time Functions