Manuals/calci/MINUTE

Revision as of 15:12, 22 August 2018 by Devika (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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