# Manuals/calci/TIME

TIME (Hour,Minute,Second)

where,

• is a number that represents hour value
• is a number that represents minute value
• is a number that represents seconds value
• TIME(),returns the serial number of a particular time.

## Description

TIME(Hour, Minute, Second)

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 >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 is negative, it is subtracted from 23:59:59 and displayed as hour value.
• If >59, it is converted into hours and minutes.
• If >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
```

TIME