Spread 8.0 Documentation
MINUTE
Support Options
Formula Reference > Built-In Functions > MINUTE

Glossary Item Box

MINUTE


Name

Minute

Description

Returns the minute corresponding to the provided time value.

Syntax

MINUTE(time)

Remarks

Specify the time argument as a serial value or time value. To provide a serial value from a time value, use the NOW or TIME function. The minute is returned as an integer, ranging from 0 to 59.

Spread's calc engine processes dates as a numeric value 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, which is the value that the DATE function returns. Use the TIME function to return the serial value for the time value (the fraction of a day).

The time serial value is a decimal fraction 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.).

See also DATE, DAY, HOUR, MONTH, NOW, SECOND, TIME, TODAY, WEEKDAY, and YEAR.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

MINUTE(D1)
MINUTE(.7) = 48

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.