Difference between revisions of "Manuals/calci/TIME"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
where, | where, | ||
| − | <math>SomeHour</math> is a number that represents hour value | + | *<math>SomeHour</math> is a number that represents hour value |
| − | + | *<math>SomeMinute</math> is a number that represents minute value | |
| − | <math>SomeMinute</math> is a number that represents minute value | + | *<math>SomeSecond</math> is a number that represents seconds value |
| − | |||
| − | <math>SomeSecond</math> is a number that represents seconds value | ||
| − | |||
TIME() returns the decimal number representing particular time or the time itself. | TIME() returns the decimal number representing particular time or the time itself. | ||
| − | |||
== Description == | == Description == | ||
| Line 23: | Line 19: | ||
*In ZOS, time value is returned as ''0.10479166666482342'' | *In ZOS, time value is returned as ''0.10479166666482342'' | ||
*In Calci, time value is returned as ''2:30:54 AM'' | *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). | *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> >23, it is divided by 24 and the remainder is considered as hour value. e.g. TIME(30,00,00) = 5 AM. | + | *If <math>SomeHour</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>SomeHour</math> is negative, it is subtracted from 23:59:59 and displayed as hour value. | *If <math>SomeHour</math> is negative, it is subtracted from 23:59:59 and displayed as hour value. | ||
*If <math>SomeMinute</math> >59, it is converted into hours and minutes. | *If <math>SomeMinute</math> >59, it is converted into hours and minutes. | ||
| − | * | + | *If <math>SomeSecond</math> >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. | ||
| − | |||
== Examples == | == Examples == | ||
| Line 73: | Line 69: | ||
| class="sshl_f" |0.15277777777373558 | | class="sshl_f" |0.15277777777373558 | ||
|} | |} | ||
| + | |||
*If the TIME() function is used in Calci, following results are obtained. | *If the TIME() function is used in Calci, following results are obtained. | ||
| Line 81: | Line 78: | ||
|- class="even" | |- class="even" | ||
| class="ssh1_f" |3 | | class="ssh1_f" |3 | ||
| + | | class=" " |40 | ||
| class=" " |20 | | class=" " |20 | ||
| − | | class=" " |- | + | | class=" " | |
| − | | class=" | + | |
| + | |- class="odd" | ||
| + | | class="ssh1_f" |20 | ||
| class=" " |00 | | class=" " |00 | ||
| class=" " |00 | | class=" " |00 | ||
| − | |||
| − | |||
| class=" " | | | class=" " | | ||
| + | |||
| + | |- class="even" | ||
| + | | class="ssh1_f" |-2 | ||
| + | | class=" " |00 | ||
| + | | class=" " |00 | ||
| class=" " | | | class=" " | | ||
|- class="odd" | |- class="odd" | ||
| − | | class="ssh1_f" | | + | | class="ssh1_f" |35 |
| − | |||
| − | |||
| class=" " |30 | | class=" " |30 | ||
| − | |||
| class=" " |00 | | class=" " |00 | ||
| − | |||
| − | |||
| − | |||
| class=" " | | | class=" " | | ||
|- class="even" | |- class="even" | ||
| − | | class="ssh1_f | + | | class="ssh1_f" |00 |
| − | + | | class=" " |75 | |
| − | | class=" " | | ||
| class=" " |00 | | class=" " |00 | ||
| + | | class=" " | | ||
| + | |||
| + | |- class="odd" | ||
| + | | class="ssh1_f" |00 | ||
| class=" " |00 | | class=" " |00 | ||
| class=" " |90 | | class=" " |90 | ||
| + | | class=" " | | ||
| + | |||
| + | |- class="even" | ||
| + | | class="ssh1_f" |3.5 | ||
| + | | class=" " |40 | ||
| class=" " |00 | | class=" " |00 | ||
| + | | class=" " | | ||
| + | |||
| + | |- class="odd" | ||
| + | | class=" " | | ||
| class=" " | | | class=" " | | ||
| class=" " | | | class=" " | | ||
Revision as of 16:53, 26 December 2013
TIME(SomeHour, SomeMinute, SomeSecond)
where,
- is a number that represents hour value
- is a number that represents minute value
- is a number that represents seconds value
is a number that represents hour value
is a number that represents minute value
is a number that represents seconds valueTIME() 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 >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.
| 3 | 40 | 20 | |
| 20 | 00 | 00 | |
| -2 | 00 | 00 | |
| 35 | 30 | 00 | |
| 00 | 75 | 00 | |
| 00 | 00 | 90 | |
| 3.5 | 40 | 00 | |
=TIME(3,40,20) returns 3:40:20 AM =TIME(20,00,00) returns 8:00:00 PM =TIME(-2,00,00) returns 8:00:00 PM =TIME(35,30,00) returns 11:30:00 AM =TIME(00,75,00) returns 1:15:00 AM =TIME(00,00,90) returns 12:01:30 AM =TIME(3.5,40,00) returns 3:40:00 AM