Applies ToSharePoint Server – vydání s předplatným SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 Enterprise SharePoint v Microsoftu 365 SharePoint Foundation 2010 SharePoint Server 2010 SharePoint v Microsoftu 365 Small Business Windows SharePoint Services 3.0

Returns the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59.

Syntax

SECOND(serial_number)

Serial_number     is the time that contains the seconds you want to find. Times may be entered as text strings within quotation marks (for example, "6:45 PM"), as decimal numbers (for example, 0.78125, which represents 6:45 PM), or as results of other formulas or functions (for example, TIMEVALUE("6:45 PM")).

Remark

Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5 because it is half of a day).

Examples

Formula

Description (Result)

=SECOND("4:48:18 PM")

Seconds in the time (18)

=SECOND("4:48 PM")

Seconds in the time (0)

Potřebujete další pomoc?

Chcete další možnosti?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.