Time

Qubes 5.4 Generates a time from an hour, minute and second extracted from the time part of a date/time, or returns the time.

Syntax

Time(h, m, s[, ms])
Time(dateTime)
Time()
h = hours for the time you want to generate
m = minutes for the time you want to generate
s = seconds for the time you want to generate
ss = milliseconds for the time you want to generate

Remarks

If the time is not valid (such as 70 minutes), the function will return #VAL!.

If a single parameter is entered, it will be interpreted as a date/time, and the time portion will be extracted.

If no parameter is entered, it will return the current time.

To perform the inverse operation and break down the time, use Hour, Minute and Second.

Examples

Time(13, 45, 28) = 13:45:28
Date(13, 75, 28) = #VAL! because the minutes are 75 (incorrect)

Classification

DateTime