TIMEVALUE

TIMEVALUEλŠ” λ”°μ˜΄ν‘œλ‘œ 묢인 ν…μŠ€νŠΈμ—μ„œ λ‚΄λΆ€ μ‹œκ°„ 번호λ₯Ό κ΅¬ν•˜λ©° κ°€λŠ₯ν•œ μ‹œκ°„ μž…λ ₯ ν˜•μ‹μ„ ν‘œμ‹œν•  수 μžˆμŠ΅λ‹ˆλ‹€.

note

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!