writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 71:
Line 71: − + Line 77:
Line 77: − + + + + + + + − + Line 88:
Line 94: − + Line 94:
Line 100: − + Line 100:
Line 106: − + Line 106:
Line 112: − + Line 112:
Line 118: − + Line 118:
Line 124: − + Line 125:
Line 131: − + − + − + − + − + − + − +
no edit summary
*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">
{| 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
| class=" " |
| class=" " |
|- class="even"
|- class="odd"
| class="ssh1_f" |-2
| class="ssh1_f" |-2
| class=" " |00
| class=" " |00
| class=" " |
| class=" " |
|- class="odd"
|- class="even"
| class="ssh1_f" |35
| class="ssh1_f" |35
| class=" " |30
| class=" " |30
| class=" " |
| class=" " |
|- class="even"
|- class="odd"
| class="ssh1_f" |00
| class="ssh1_f" |00
| class=" " |75
| class=" " |75
| class=" " |
| class=" " |
|- class="odd"
|- class="even"
| class="ssh1_f" |00
| class="ssh1_f" |00
| class=" " |00
| class=" " |00
| class=" " |
| class=" " |
|- class="even"
|- class="odd"
| class="ssh1_f" |3.5
| class="ssh1_f" |3.5
| class=" " |40
| class=" " |40
| class=" " |
| class=" " |
|- class="odd"
|- class="even"
| class=" " |
| class=" " |
| class=" " |
| class=" " |
|}
|}
=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''
== See Also ==
== See Also ==