User Manual

Formula editor 53
Parameter
Time
This parameter can be entered in either the form of a Time function or as a
Variable of the type
Time.
Examples
TimeToNumber(Time()) = current date and current time shown as a Number
(in days since December 1899)
TimeToNumber(Time(1999;12;31;23;59;59)) = 36525.95832
TimeToNumber(Time('TestYear';'TestMonth';'TestDay')) = value of the Com-
mon variables as number of days as
Number
TimeToText
Syntax
y = TimeToText(Time)
Returns the entered time as
Text.
y = TimeToText(Time;Format)
Returns the entered time as
Text in the required format.
Parameter
Time
This parameter can be entered in either the form of a Time function or as a
Variable of the type
Date/Time.
Format
Defines in which format or sequence the text must be entered. This pa-
rameter must be enclosed with Inverted commas and can be composed
of the following code characters:
Character Meaning Example
y
2-place date in years
03
yyyy
4-place date in years
1999
M
1- or 2-place date in months
4, 12
MM
2-place date in months
04, 12
MMM
Abbreviated name of month
Jul, Aug
MMMM
Month name
July, August
d
1- or 2-place date in days
2, 25
dd
2-place date in days
02, 25
h
1- or 2-place time in hours (1...12 AM/PM)
5, 11
hh
2-place time in hours (1...12 AM/PM)
05, 11
H
1- or 2-place time in hours (0...23)
8, 17
HH
2-place time in hours (0...23)
08, 17
m
1- or 2-place time in minutes
2, 25
mm
2-place time in minutes
02, 25
s
1- or 2-place time in seconds
3, 55