The time function formats the expression as time according to the string
given as format-code. If the format code is omitted, the time format set
in the operating system is used.
Syntax:
Time( expression [ , format-code ])
The examples below assume the 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=0.375
String:
09:00:00
09.00.00
Number:
0.375
0.375
Time( A ) where
A=35648.375
String:
09:00:00
09.00.00
Number:
35648.375
35648.375
Time( A, 'hh-mm' ) where
A=0.99999
String:
23-59
23-59
Number:
0.99999
0.99999
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!