Manuals/calci/MINUTE

From ZCubes Wiki
Revision as of 14:31, 9 July 2018 by Devika (talk | contribs)
Jump to navigation Jump to search
MINUTE (Value)


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

MINUTE() converts a input time to a minute.

Description

MINUTE(Value)

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

Related Videos

MINUTE

See Also

References