Manuals/calci/MINUTE

Revision as of 13:33, 23 December 2013 by Swapna (talk | contribs)

MINUTE(sn)

  • where   is the time or serial number of time to find the minute value.

MINUTE() returns the minute value from the input time.

Description

MINUTE(sn)

For Example,

MINUTE("4:30 AM") returns 30

  • Argument   can be time in the form of text or as a result of any other functions.
  • Argument   should be enclosed in quotes e.g. "11:00 AM".
  • If   is invalid, Calci returns an #ERROR message.
  • The output minute value is the value in integers, ranging from '0' to '59'.

Examples

Function Output
MINUTE("12:00:00 AM") 0
MINUTE("5:59 PM") 59
MINUTE("2:30") 30
MINUTE("10:33:59 PM") 33

See Also

References