TIMEVALUE

TIMEVALUE๋Š” ๋”ฐ์˜ดํ‘œ๋กœ ๋ฌถ์ธ ํ…์ŠคํŠธ์—์„œ ๋‚ด๋ถ€ ์‹œ๊ฐ„ ๋ฒˆํ˜ธ๋ฅผ ๊ตฌํ•˜๋ฉฐ ๊ฐ€๋Šฅํ•œ ์‹œ๊ฐ„ ์ž…๋ ฅ ํ˜•์‹์„ ํ‘œ์‹œํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์ฐธ๊ณ  ์•„์ด์ฝ˜

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)


์†Œ์ˆ˜์ ์œผ๋กœ ํ‘œ์‹œ๋˜๋Š” ๋‚ด๋ถ€๊ฐ’์€ LibreOffice๊ฐ€ ๋‚ ์งœ ๋ฐ์ดํ„ฐ์˜ ๊ณ„์‚ฐ์— ์‚ฌ์šฉํ•˜๋Š” ๋‚ ์งœ ์‹œ์Šคํ…œ์˜ ๊ฒฐ๊ณผ์ž…๋‹ˆ๋‹ค.

๋งŒ์•ฝ ํ…์ŠคํŠธ ๋ฌธ์ž์—ด์ด ๋…„ ๋˜๋Š” ์›”, ์ผ๋„ ํฌํ•จํ•œ๋‹ค๋ฉด, TIMEVALUE๋Š” ๋ณ€ํ™˜๋œ ๋‚ด์šฉ ์ค‘ ๋ถ„์ˆ˜ ๋ถ€๋ถ„๋งŒ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

Syntax

TIMEVALUE("Text")

Text๋Š” ์œ ํšจํ•œ ์‹œ๊ฐ„ ํ‘œํ˜„์ด๊ณ  ๋”ฐ์˜ดํ‘œ ์•ˆ์— ์ž…๋ ฅ๋˜์–ด์•ผ ํ•ฉ๋‹ˆ๋‹ค.

Example

=TIMEVALUE("4PM")์€ 0.67์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ์‹œ๊ฐ„ ์„œ์‹์— HH:MM:SS์„ ์ ์šฉํ•˜๋ฉด 16:00:00์„ ์–ป๊ฒŒ ๋ฉ๋‹ˆ๋‹ค.

=TIMEVALUE("24:00")์€ 1์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ์‹œ๊ฐ„ ์„œ์‹์— HH:MM:SS์„ ์ ์šฉํ•˜๋ฉด ๊ฐ’์€ 00:00:00์ด ๋ฉ๋‹ˆ๋‹ค.

Date & Time Functions

DATE

[text/scalc/01/func_datedif.xhp#datedif not found].

DATEVALUE

DAY

DAYS

DAYS360

EASTERSUNDAY

EDATE

EOMONTH

HOUR

[text/scalc/01/func_isoweeknum.xhp#isoweeknum not found].

MINUTE

MONTH

NETWORKDAYS

NETWORKDAYS.INTL

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKNUM

WEEKNUM_ADD

[text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo not found].

WORKDAY

WORKDAY.INTL

YEAR

YEARFRAC

Please support us!