7 type conversion functions, 1 numbertotext, 2 numbertotime – Metrohm viva 1.1 (ProLab) User Manual

Page 78: Numbertotext, Numbertotime

Advertising
background image

2.3 Formula editor

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

66

■■■■■■■■

viva 1.1 (for process analysis)

2.3.4.7

Type conversion functions

2.3.4.7.1

NumberToText

Dialog window: Formula editor

Operators/Functions

Syntax
y = NumberToText(number)

Returns the entered number as Text.

Parameters
Number

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

Examples
NumberToText(–55.3) = –55.3

NumberToText('CV.AverageTemp') = Value of the common variable
(AverageTemp) as Text

2.3.4.7.2

NumberToTime

Dialog window: Formula editor

Operators/Functions

Syntax
y = NumberToTime(number)

Returns the entered number as Date/Time, where the number is interpre-
ted 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 Number type.

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

NumberToTime(35780.55) = 1997-12-16 14:12:00 UTC+1 (depen-
dent on the system time)

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

Advertising