САНА

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 барои ҳисобкунӣ истифода мешавад.

If the text string also includes a year, month, or day, TIMEVALUE only returns the fractional part of the conversion.

Syntax

DATEVALUE("Матн")

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

САНА

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

[text/scalc/01/func_datevalue.xhp#datevalue not found].

[text/scalc/01/func_day.xhp#day not found].

[text/scalc/01/func_days.xhp#days not found].

[text/scalc/01/func_days360.xhp#days360 not found].

[text/scalc/01/func_eastersunday.xhp#eastersunday not found].

[text/scalc/01/func_edate.xhp#edate not found].

[text/scalc/01/func_eomonth.xhp#eomonth not found].

[text/scalc/01/func_hour.xhp#hour not found].

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

[text/scalc/01/func_minute.xhp#minute not found].

[text/scalc/01/func_month.xhp#month not found].

NETWORKDAYS

NETWORKDAYS.INTL

[text/scalc/01/func_now.xhp#now not found].

[text/scalc/01/func_second.xhp#second not found].

[text/scalc/01/func_time.xhp#time not found].

[text/scalc/01/func_timevalue.xhp#timevalue not found].

[text/scalc/01/func_today.xhp#today not found].

WEEKDAY

[text/scalc/01/func_weeknum.xhp#weeknum not found].

[text/scalc/01/func_weeknumadd.xhp#weeknumadd not found].

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

[text/scalc/01/func_workday.xhp#workday not found].

WORKDAY.INTL

[text/scalc/01/func_year.xhp#year not found].

[text/scalc/01/func_yearfrac.xhp#yearfrac not found].

Please support us!