The time# function evaluates
the expression as time according
to the string given as format-code.
If the format code is omitted, the default time format set in the operating
system is used.
Syntax:
time#(expression [ , format-code ])
The examples below assume the two following operating system settings:
Default
setting 1
Default
setting 2
Time format
hh:mm:ss
hh.mm.ss
Example
Results
Setting 1
Setting 2
time#( A ) where
A=09:00:00
String:
09:00:00
09:00:00
Number:
0.375
-
time#(
A, 'hh.mm' ) where
A=09.00
String:
09.00
09.00
Number:
0.375
0.375
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!