beautypg.com

2 numbertotime, 3 texttonumber, Numbertotime – Metrohm tiBase 1.1 User Manual

Page 65: Texttonumber

background image

■■■■■■■■■■■■■■■■■■■■■■

2 General program functions

tiBase 1.1

■■■■■■■■

57

Examples
NumberToText(-55.3) = -55.3

NumberToText('CV.AverageTemp') = Vale of the common variable
(AverageTemp) als Text

2.4.4.7.2

NumberToTime

Dialog window: Formula editor

Operators/Functions

Syntax
y = NumberToTime(number)

Gives the entered number as Date/Time, whereby the number is inter-
preted as the number of days since December 30, 1899 at 01 hours.

Parameters
Number

The parameter can be indicated either directly as a number or as a variable
of the type Number.

Examples
NumberToTime(35545.526) = 1997-05-25 14:37:26 UTC+2
(dependent on the system time)

NumberToTime(35780.55) = 1997-12-16 14:12:00 UTC+1 (Num-
berToTime(35545.526) = 1997-05-25 14:37:26 UTC+2 (dependent on the
system time)

NumberToTime('CV.TestDate') = Value of the common variable (Test-
Date) as Date/Time

2.4.4.7.3

TextToNumber

Dialog window: Formula editor

Operators/Functions

Syntax
y = TextToNumber(Text)

Gives the entered text as a number.

Parameters
Text

The parameter may only contain numerical characters or variables of
the type Text, as otherwise a type conversion is not possible. The result of
this conversion or the calculation would then be invalid. In addition, text
must be marked by inverted commas.

Examples
TextToNumber("-55.3") = -55.3