User:Syranzi/Documentation/How Tos/Calc: SECOND function

From Apache OpenOffice Wiki
Revision as of 09:49, 17 July 2018 by Sancho (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SECOND

SECOND

Returns the seconds of a given time.

指定された時刻の秒を返します。

Syntax:

構文:

SECOND(time)

returns the seconds of time as a number, 0 - 59.
time may be text or a date-time serial number.

SECOND(時刻)

「時刻」の秒を数字 (059) として返します。
「時刻」は文字、または日付・時刻の連番です。

Example:

例:

SECOND("2008-01-06 21:30:15")

returns 15.

SECOND(A1)

where cell A1 contains the time 9:25:10 as a date-time serial number, returns 10.

SECOND("2008-01-06 21:30:15")

15 秒にあたる「15」を返します。

SECOND(A1)

セル A1 が時刻「9 時 25 分 10 秒 (9:25:10)」を日付・時刻の連番として含む場合、「10」を返します。



See Also

関連項目

Personal tools