Difference between revisions of "Manuals/calci/TIME"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TIME'''(SomeHour, SomeMinute, SomeSecond) where, '''SomeHour''' - a number represents the hour. '''SomeM...") |
|||
(10 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | <div | + | <div style="font-size:30px">'''TIME (Hour,Minute,Second)'''</div><br/> |
+ | |||
+ | where, | ||
+ | |||
+ | *<math>Hour</math> is a number that represents hour value | ||
+ | *<math>Minute</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. | ||
+ | |||
+ | == 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 <math>Hour</math> >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> is negative, it is subtracted from 23:59:59 and displayed as hour value. | ||
+ | *If <math>Minute</math> >59, it is converted into hours and minutes. | ||
+ | *If <math>Second</math> >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. | |
− | |||
− | |||
− | + | <div id="6SpaceContent" class="zcontent" align="left"> | |
− | + | {| id="TABLE3" class="SpreadSheet blue" | |
− | + | |- class="even" | |
− | + | | class=" " | '''Function''' | |
+ | | class=" " | '''Output''' | ||
− | TIME | + | |- class="odd" |
+ | | class="sshl_f" |TIME(3,40,20) | ||
+ | | class="sshl_f" |0.15300925925839692 | ||
− | + | |- class="even" | |
+ | | class="sshl_f" |TIME(20,00,00) | ||
+ | | class="sshl_f" |0.8333333333284827 | ||
− | + | |- class="odd" | |
− | - | + | | class="sshl_f" |TIME(-4,00,00) |
− | + | | class="sshl_f" |0.8333333333284827 | |
− | + | |- class="even" | |
+ | | class="sshl_f" |TIME(35,30,00) | ||
+ | | class="sshl_f" |0.47916666666424135 | ||
− | + | |- class="odd" | |
+ | | class="sshl_f" |TIME(00,75,00) | ||
+ | | class="sshl_f" |0.052083333328482695 | ||
− | TIME | + | |- class="even" |
+ | | class="sshl_f" |TIME(00,00,100) | ||
+ | | class="sshl_f" |0.001157407408754807 | ||
− | + | |- class="odd" | |
+ | | class="sshl_f" |TIME(3.5,40,00) | ||
+ | | class="sshl_f" |0.15277777777373558 | ||
+ | |} | ||
− | + | *TIME("next day") = 11:51:10 AM | |
− | TIME | + | *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=" | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
− | | class=" " | | + | | class="ssh1_f" |ColumnA |
− | | | + | | class=" " |ColumnB |
− | | | + | | class=" " |ColumnC |
− | | | + | | class=" " |ColumnD |
− | + | ||
|- class="odd" | |- class="odd" | ||
− | | class=" " | | + | | class="ssh1_f" |3 |
− | | class=" " | | + | | class=" " |40 |
− | | class=" " | | + | | class=" " |20 |
− | | class=" | + | | class=" " | |
− | + | ||
|- class="even" | |- class="even" | ||
− | | class=" " | | + | | class="ssh1_f" |20 |
− | | class=" | + | | class=" " |00 |
− | | class=" | + | | class=" " |00 |
− | | class=" | + | | class=" " | |
− | | class=" " | | + | |
+ | |- class="odd" | ||
+ | | class="ssh1_f" |-4 | ||
+ | | class=" " |00 | ||
+ | | class=" " |00 | ||
+ | | class=" " | | ||
+ | |||
+ | |- class="even" | ||
+ | | class="ssh1_f" |35 | ||
+ | | class=" " |30 | ||
+ | | class=" " |00 | ||
+ | | class=" " | | ||
+ | |||
|- class="odd" | |- class="odd" | ||
− | + | | class="ssh1_f" |00 | |
− | | class=" | + | | class=" " |75 |
− | | class=" | + | | class=" " |00 |
− | | class=" | + | | class=" " | |
− | | class=" " | | + | |
|- class="even" | |- class="even" | ||
− | + | | class="ssh1_f" |00 | |
− | | class=" | + | | class=" " |00 |
− | | class=" " | | + | | class=" " |90 |
− | | class=" " | | + | | class=" " | |
− | | class=" " | | + | |
|- class="odd" | |- class="odd" | ||
− | | class=" " | | + | | class="ssh1_f" |3.5 |
− | | class=" | + | | class=" " |40 |
− | + | | class=" " |00 | |
− | | class=" " | | + | | class=" " | |
− | | class=" " | | + | |
− | |||
|- class="even" | |- class="even" | ||
− | + | | class=" " | | |
− | | class=" " | | + | | class=" " | |
− | | class=" " | | + | | class=" " | |
− | | class=" " | | + | | class=" " | |
− | | class=" " | | ||
|} | |} | ||
− | + | =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== | ||
+ | |||
+ | {{#ev:youtube|Zzo1G3rxLDk|280|center|TIME}} | ||
+ | |||
+ | == See Also == | ||
+ | |||
+ | *[[Manuals/calci/HOUR | HOUR]] | ||
+ | *[[Manuals/calci/MINUTE | MINUTE]] | ||
+ | *[[Manuals/calci/SECOND | SECOND]] | ||
+ | *[[Manuals/calci/TIMEVALUE | TIMEVALUE]] | ||
+ | |||
+ | ==References== | ||
+ | |||
+ | *[http://en.wikipedia.org/wiki/Time Time] | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | |||
+ | *[[ Z3 | Z3 home ]] |
Latest revision as of 05:48, 27 May 2022
TIME (Hour,Minute,Second)
where,
- is a number that represents hour value
- is a number that represents minute value
- TIME(),returns the serial number of a particular time.
is a number that represents seconds value
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
See Also
References