Manuals/calci/TIME

TIME(SomeHour, SomeMinute, SomeSecond)

where,

$SomeHour$ is a number that represents hour value

$SomeMinute$ is a number that represents minute value

$SomeSecond$ is a number that represents seconds value

TIME() returns the decimal number representing particular time or the time itself.

Description

TIME(SomeHour, SomeMinute, SomeSecond)

For Example,

TIME(2,30,54)

• In ZOS, time value is returned as 0.10479166666482342
• In Calci, time value is returned as 2:30:54 AM

• Calci displays the time considering a 24 hour clock from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 PM).
• The decimal output of time value is in the range from '0' to '0.99988426'. e.g. 12:00 PM is half of a day, represented as '0.5' or '0.25'.
• If $SomeHour$ >23, it is divided by 24 and the remainder is considered as hour value. e.g. TIME(30,00,00) = 5 AM.
• If $SomeHour$ is negative, it is subtracted from 23:59:59 and displayed as hour value.
• If $SomeMinute$ >59, it is converted into hours and minutes.
• Argument $SomeSecond$ >59, it is converted into hours, minutes and seconds.
• If any arguments are invalid, Calci returns an #ERROR message.
• If any argument is non-integer, it is truncated.

Examples

• If the TIME() function is used in ZOS, following results are obtained.

Function	Output
TIME(3,40,20)	0.15300925925839692
TIME(20,00,00)	0.8333333333284827
TIME(-4,00,00)	0.8333333333284827
TIME(35,30,00)	0.47916666666424135
TIME(00,75,00)	0.052083333328482695
TIME(00,00,100)	0.001157407408754807
TIME(3.5,40,00)	0.15277777777373558

• If the TIME() function is used in Calci, following results are obtained.

3	20	-2	35	00	00	3.5
40	00	00	30	75	00	40
20	00	00	00	00	90	00

=TIME(3,40,20) returns 3:40:20 AM =TIME(20,00,00) returns 8:00:00 PM =TIME(-2,00,00) returns 8:00:00 PM =TIME(35,30,00) returns 11:30:00 AM =TIME(00,75,00) returns 1:15:00 AM =TIME(00,00,90) returns 12:01:30 AM =TIME(3.5,40,00) returns 3:40:00 AM

See Also

• HOUR
• MINUTE
• SECOND
• TIMEVALUE

References

• Time