Time()

Time()

Category: Time

Syntax: Time ( hours ; minutes ; seconds )

Parameters: hours ”a number representing the hours portion of the desired time value; minutes ”a number representing the minutes portion of the desired time value; seconds ”a number representing the seconds portion of the desired time value.

Description: Returns a time value built from the specified hours , minutes , and seconds parameters. The resulting value accurately calculates the effect of fractional parameters. Similarly, although the typical range for the minutes and seconds parameters is from 0 to 59, any values above or below are compensated for in the resulting time value.

Examples:

 Time (8 ; 34; 15) 

Returns 8:34:15 .

 Time (15.25 ; 0 ; 0 ) 

Returns 15:15:00 .

 Time (22 ; 70 ; 70 ) 

Returns 23:11:10 .

 Time (12 ; -30 ; 0) 

Returns 11:30:00 .

Comments:

The Time() function is often used in conjunction with the Hour () , Minute() , and Seconds() functions. For instance, the following formula takes the current time and returns the time of the next lowest hour:

 Time (Hour (Get (CurrentTime));0;0)