$Time
Function
Returns the current time of day in the format specified.
Syntax
$TIME(time-format,'first-delimiter', 'second-delimiter')
Where
| Argument | Value | Specifies | Default value |
|---|---|---|---|
| time-format | 1 | Returns the time of day as hhdmmdss (d=delimiter) | 1 |
| 2 | Returns the time of day as hhdmmdssdttt (d=delimiter) | ||
| first-delimiter | 1 character only | Character to place between time units HH, MM, and SS | : (colon) |
| second-delimiter | 1 character only, second-delimiter | Character to place between time units SS and TTT | . (period) |
The second-delimiter applies only if time-format is 2. You must enclose the delimiters with single quotation marks.
You can suppress either the first-delimiter or second-delimiter character by using a single quoted null string.
Examples
| $TIME(argument) | Returns... |
|---|---|
| $TIME | HH:MM:SS |
| $TIME(1) | HH:MM:SS |
| $TIME(1,'-') | HH-MM-SS |
| $TIME(1,' ') | HH MM SS |
| $TIME(1,) | HHMMSS |
| $TIME(2) | HH:MM:SS.TTT |
| $TIME(2,'-') | HH-MM-SS.TTT |
| $TIME(2,,) | HHMMSSTTT |