Excel. 3
.
, .
Excel Excel. .. 3 λ.
Excel. , , (, ).
, . , :
1. . :
- 45 ?
- 2 ?
- 95 ?
- 2 ?
- 2100 .?
- 14 ?
- ?
- ?
- ?
, , .
2. ( ). , . :
- ;
- ;
- ;
- .
3. , :
1) ;
2) ;
3) ;
4) ;
5) .
1 1900 .
:
0,0 = 00:00:00
0,5 = 12:00:00
0,8 = 19:12:00
1,0 = 01.01.1900 . 00:00:00 ( 01.01.1900)
1,6 = 01.01.1900 . 14:24:00
32 = 01.02.1900 .
366 = 31.12.1900.
, = 1/24 ≈ 0,04167, 1/24/60 ≈ 0,000694, = 365 ( ) . . , , , .
- (, 01.09.2016; 1 2016; .2016; 2016/09/01 .).
. . ꅻ .
( ).
:
|
|
1, 6, 12, 31 | ||
01, 06, 12, 31 | ||
() | , , , , , , | |
() | , | |
1, 2, 3, 4, 10, 11, 12 | ||
01, 02, 03, 11, 12 | ||
, , , , , , , , , , , | ||
, | ||
98, 01, 16 | ||
1998, 2001, 2016 | ||
24- | 1, 2, 20, 23 | |
24- | 01, 02, 20, 23 | |
1, 5, 15, 40, 59 | ||
01, 05, 15, 40, 59 | ||
1, 5, 15, 40, 59 | ||
01, 05, 15, 40, 59 | ||
AM/PM | 12- , AM, PM | 10:00 PM 08:16 AM |
(.), (/), (-), (,), , , .
:
. 1 2016 .
// () 01/09/16 ()
, ̠ , 01
à 2016
-à 09-16
.̠ 1.9
.. :젠 01.09.16 8:30
::/Ġ 08:30:00/
: 30:00
, , , Ļ.
! , Excel . , 01.09.2015 = 42 248. 01.01.1900. .
, , , , , .
:
+ =
1 2 =
* 24 = ( )
* 24 * 60 = ( )
* 24 * 60 * 60 = ( )
,
, 50 1 2016 .
, 01.09.2016 , , .
, , .. 31 :
, Excel . .
Office . .
| |||||
() | 1 31 | =(12.10.2016) | 12 | ||
(; []) | :
= 1, 1 () 7 () = 2, 1 () 7 () = 3, 0 () 6 () , 1 | =(13.10.2016) | 3 () | ||
=(13.10.2016;2) | 2 () | ||||
=(12.10.2016;3) | 0 () | ||||
() | 1 12 | =(12.10.2016) | 10 | ||
() | 1900 9999 | =(12.10.2016) | 2016 | ||
(_) | =(14:15:07) | 14 | |||
(_) | =(14:15:07) | 15 | |||
(_) | =(14:15:07) | 7 | |||
() | ( ) | =() | 17.10.2018 23:12 | ||
() | ( 00:00:00) | =() | 17.10.2018 | ||
(_; _) | _ _ | =("12.10.2016";1) | 12.11.2016 | ||
=("12.10.2016";6) | 12.04.2017 | ||||
(_; _) | _ _ (0 | =("12.10.2016";0) | 31.10.2016 | ||
=("12.10.2016";2) | 31.12.2016 | ||||
=("12.10.2016";12) | 31.10.2016 | ||||
=("12.10.2016";-1) | 30.09.2016 | ||||
(;;) | , | =(2016;10;11) | 11.10.2016 | ||
(_; _; ) | , . , , . | =("17.04.2017"; 7) | 26.04.2017 | ||
(_; _; ) | , ( ). , , . | = ("01.04.2017"; "20.04.2017") | 14 |
.
, (31 ) :
, ( ), 12 31 .
1. ?
2. , ?
3. ?
4. : : 17 .?
5. ?