Difference between revisions of "Manuals/calci/TIME"

Latest revision as of 04:48, 27 May 2022

TIME (Hour,Minute,Second)

where,

$Hour$ is a number that represents hour value
$Minute$ 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 $Hour$ >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 $Hour$ is negative, it is subtracted from 23:59:59 and displayed as hour value.
If $Minute$ >59, it is converted into hours and minutes.
If $Second$ >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

TIME("next day") = 11:51:10 AM

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

References

Time

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-=TIME(SomeHour, SomeMinute, SomeSecond)=
+<div style="font-size:30px">'''TIME (Hour,Minute,Second)'''</div><br/>
 where,
-<math>SomeHour</math> is a number that represents hour value
+*<math>Hour</math> is a number that represents hour value
+*<math>Minute</math> is a number that represents minute value
-<math>SomeMinute</math> is a number that represents minute value
+*<math>Second</math> is a number that represents seconds value
+**TIME(),returns the serial number of a particular time.
-<math>SomeSecond</math> is a number that represents seconds value
-TIME() returns the decimal number representing particular time or the time itself.
 == Description ==
-TIME(SomeHour, SomeMinute, SomeSecond)
+TIME(Hour, Minute, Second)
 For Example,
@@ Line 23: / Line 18: @@
 *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'.
+*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 <math>SomeHour</math> &gt;23, it is divided by 24 and the remainder is considered as hour value. e.g. TIME(30,00,00) = 5 AM.
+*If <math>Hour</math> &gt;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 <math>SomeHour</math> is negative, it is subtracted from 23:59:59 and displayed as hour value.
+*If <math>Hour</math> is negative, it is subtracted from 23:59:59 and displayed as hour value.
-*If <math>SomeMinute</math> &gt;59, it is converted into hours and minutes.
+*If <math>Minute</math> &gt;59, it is converted into hours and minutes.
-*Argument <math>SomeSecond</math> &gt;59, it is converted into hours, minutes and seconds.
+*If <math>Second</math> &gt;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 ==
@@ Line 74: / Line 69: @@
 |}
-*If the TIME() function is used in Calci, following results are obtained.
+*TIME("next day") = 11:51:10 AM
+*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.
 <div id="6SpaceContent" class="zcontent" align="left">
@@ Line 80: / Line 77: @@
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class="ssh1_f" |3
+| class="ssh1_f" |ColumnA
+| class="  " |ColumnB
+| class="  " |ColumnC
+| class="  " |ColumnD
+|- class="odd"
+| class="ssh1_f" |3
+| class="  " |40
 | class="  " |20
-| class="  " |-2
+| class="  " |
-| class="  " |35
+|- class="even"
+| class="ssh1_f" |20
 | class="  " |00
 | class="  " |00
-| class="  " |3.5
-| class="  " |
-| class="  " |
 | class="  " |
 |- class="odd"
-| class="ssh1_f" | 40
+| class="ssh1_f" |-4
 | class="  " |00
 | class="  " |00
+| class="  " |
+|- class="even"
+| class="ssh1_f" |35
 | class="  " |30
+| class="  " |00
+| class="  " |
+|- class="odd"
+| class="ssh1_f" |00
 | class="  " |75
 | class="  " |00
-| class="  " |40
-| class="  " |
-| class="  " |
 | class="  " |
 |- class="even"
-| class="ssh1_f" | 20
+| class="ssh1_f" |00
-| class="  " |00
-| class="  " |00
-| class="  " |00
 | class="  " |00
 | class="  " |90
+| class="  " |
+|- class="odd"
+| class="ssh1_f" |3.5
+| class="  " |40
 | class="  " |00
+| class="  " |
+|- class="even"
+| class="  " |
 | class="  " |
 | class="  " |
@@ Line 116: / Line 131: @@
 |}
-=TIME(3,40,20) returns ''3:40:20 AM''
+ =TIME(A1,B1,C1) returns ''3:40:20 AM''
-=TIME(20,00,00) returns ''8:00:00 PM''
+ =TIME(A2,B2,C2) returns ''8:00:00 PM''
-=TIME(-2,00,00) returns ''8:00:00 PM''
+ =TIME(A3,B3,C3) returns ''8:00:00 PM''
-=TIME(35,30,00) returns ''11:30:00 AM''
+ =TIME(A4,B4,C4) returns ''11:30:00 AM''
-=TIME(00,75,00) returns ''1:15:00 AM''
+ =TIME(A5,B5,C5) returns ''1:15:00 AM''
-=TIME(00,00,90) returns ''12:01:30 AM''
+ =TIME(A6,B6,C6) returns ''12:01:30 AM''
-=TIME(3.5,40,00) returns ''3:40:00 AM''
+ =TIME(A7,B7,C7) returns ''3:40:00 AM''
+==Related Videos==
+{{#ev:youtube|Zzo1G3rxLDk|280|center|TIME}}
 == See Also ==
@@ Line 134: / Line 153: @@
 *[http://en.wikipedia.org/wiki/Time Time]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/TIME"

Latest revision as of 04:48, 27 May 2022

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search