Manuals/calci/SECOND

Revision as of 14:49, 25 June 2015 by Swapna (talk | contribs)

SECOND(sn)

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

SECOND() returns the seconds value from the input time.

Description

SECOND(sn)

For Example,

SECOND("3:45:20 AM") returns 20

  • 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:00 AM".
  • If   is invalid, Calci returns an #ERROR message.
  • The output seconds value is the value in integers, ranging from '0' to '59'.

Examples

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

Related Videos

SECOND

See Also

References