Difference between revisions of "Manuals/calci/TIME"

From ZCubes Wiki
Jump to navigation Jump to search
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
=TIME(SomeHour, SomeMinute, SomeSecond)=
+
<div style="font-size:30px">'''TIME (Hour,Minute,Second)'''</div><br/>
  
 
where,
 
where,
  
−
*<math>SomeHour</math> is a number that represents hour value
+
*<math>Hour</math> is a number that represents hour value
−
*<math>SomeMinute</math> is a number that represents minute value
+
*<math>Minute</math> is a number that represents minute value
−
*<math>SomeSecond</math> is a number that represents seconds value
+
*<math>Second</math> is a number that represents seconds value
−
 
+
**TIME(),returns the serial number of a particular time.
−
TIME() returns the decimal number representing particular time or the time itself.
 
  
 
== Description ==
 
== Description ==
  
−
TIME(SomeHour, SomeMinute, SomeSecond)
+
TIME(Hour, Minute, Second)
  
 
For Example,
 
For Example,
Line 23: Line 22:
 
*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).
 
*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'.  
 
*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' or '0.25'.
+
*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.
−
*If <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 arguments are invalid, Calci returns an #ERROR message.
 
*If any argument is non-integer, it is truncated.
 
*If any argument is non-integer, it is truncated.
Line 70: Line 69:
 
|}
 
|}
  
 +
*TIME("next day") = 11:51:10 AM
  
−
*If the TIME() function is used in Calci, following results are obtained.
+
*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">
 
<div id="6SpaceContent" class="zcontent" align="left">
Line 77: Line 77:
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- 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="  " |40
 
| class="  " |20
 
| class="  " |20
 
| class="  " |
 
| class="  " |
  
−
|- class="odd"
+
|- class="even"
 
| class="ssh1_f" |20
 
| class="ssh1_f" |20
 
| class="  " |00
 
| class="  " |00
Line 88: Line 94:
 
| class="  " |
 
| class="  " |
  
−
|- class="even"
+
|- class="odd"
−
| class="ssh1_f" |-2
+
| class="ssh1_f" |-4
 
| class="  " |00
 
| class="  " |00
 
| class="  " |00
 
| class="  " |00
 
| class="  " |
 
| class="  " |
  
−
|- class="odd"
+
|- class="even"
 
| class="ssh1_f" |35
 
| class="ssh1_f" |35
 
| class="  " |30
 
| class="  " |30
Line 100: Line 106:
 
| class="  " |
 
| class="  " |
  
−
|- class="even"
+
|- class="odd"
 
| class="ssh1_f" |00  
 
| class="ssh1_f" |00  
 
| class="  " |75
 
| class="  " |75
Line 106: Line 112:
 
| class="  " |
 
| class="  " |
  
−
|- class="odd"
+
|- class="even"
 
| class="ssh1_f" |00
 
| class="ssh1_f" |00
 
| class="  " |00
 
| class="  " |00
Line 112: Line 118:
 
| class="  " |
 
| class="  " |
  
−
|- class="even"
+
|- class="odd"
 
| class="ssh1_f" |3.5  
 
| class="ssh1_f" |3.5  
 
| class="  " |40
 
| class="  " |40
Line 118: Line 124:
 
| class="  " |
 
| class="  " |
  
−
|- class="odd"
+
|- class="even"
 
| class="  " |
 
| class="  " |
 
| class="  " |
 
| class="  " |
Line 125: 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 ==
 
== See Also ==
Line 143: Line 153:
  
 
*[http://en.wikipedia.org/wiki/Time Time]
 
*[http://en.wikipedia.org/wiki/Time Time]
 +
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 04:48, 27 May 2022

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
  • 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

Related Videos

TIME

See Also

References



Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/TIME&oldid=216953"