Revision as of 06:22, 13 March 2017

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'.
If $SomeHour$ >23, it is divided by 24 and the remainder is considered as hour value. e.g. TIME(30,00,00) = '5 AM' or '0.25'.
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.
If $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. Hour, Minute and Second values are entered in columns A, B and C respectively.

ColumnA	ColumnB	ColumnC	ColumnD
3	40	20
20	00	00
-4	00	00
35	30	00
00	75	00
00	00	90
3.5	40	00

=TIME(A1,B1,C1) returns 3:40:20 AM
=TIME(A2,B2,C2) returns 8:00:00 PM
=TIME(A3,B3,C3) returns 8:00:00 PM
=TIME(A4,B4,C4) returns 11:30:00 AM
=TIME(A5,B5,C5) returns 1:15:00 AM
=TIME(A6,B6,C6) returns 12:01:30 AM
=TIME(A7,B7,C7) returns 3:40:00 AM