December 12th 2021, 9_45 PM to 12.12.201 21_45.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date	Länge	1. LZ	2. LZ	3. LZ	MM	TT th US-Format	TT o 0	TT txt	Jahr txt	Tag DATWERT	Uhrzeit txt US	ZEITWERT	SUMME DAT+ZEITWERT
2	December 31st 2021, 9:55 AM	27	9	14	20	12	31st 2021, 9:55 AM	31	31	2021	44561	9:55 AM	0,4131944444	12/31/21 9:55
3	December 31st 2021, 9:54 AM	27	9	14	20	12	31st 2021, 9:54 AM	31	31	2021	44561	9:54 AM	0,4125	12/31/21 9:54
4	January 5th 2022, 9:16 AM	25	8	12	18	01	5th 2022, 9:16 AM	5	05	2022	44566	9:16 AM	0,3861111111	1/5/22 9:16
5	January 4th 2022, 10:27 AM	26	8	12	18	01	4th 2022, 10:27 AM	4	04	2022	44565	10:27 AM	0,4354166667	1/4/22 10:27
6	January 4th 2022, 10:27 AM	26	8	12	18	01	4th 2022, 10:27 AM	4	04	2022	44565	10:27 AM	0,4354166667	1/4/22 10:27
7	January 4th 2022, 10:27 AM	26	8	12	18	01	4th 2022, 10:27 AM	4	04	2022	44565	10:27 AM	0,4354166667	1/4/22 10:27
8	January 4th 2022, 10:26 AM	26	8	12	18	01	4th 2022, 10:26 AM	4	04	2022	44565	10:26 AM	0,4347222222	1/4/22 10:26
9	January 3rd 2022, 9:26 AM	25	8	12	18	01	3rd 2022, 9:26 AM	3	03	2022	44564	9:26 AM	0,3930555556	1/3/22 9:26
10	January 3rd 2022, 9:25 AM	25	8	12	18	01	3rd 2022, 9:25 AM	3	03	2022	44564	9:25 AM	0,3923611111	1/3/22 9:25
11	January 3rd 2022, 9:25 AM	25	8	12	18	01	3rd 2022, 9:25 AM	3	03	2022	44564	9:25 AM	0,3923611111	1/3/22 9:25
12	January 3rd 2022, 9:24 AM	25	8	12	18	01	3rd 2022, 9:24 AM	3	03	2022	44564	9:24 AM	0,3916666667	1/3/22 9:24
13	January 2nd 2022, 9:24 AM	25	8	12	18	01	2nd 2022, 9:24 AM	2	02	2022	44563	9:24 AM	0,3916666667	1/2/22 9:24
14	January 2nd 2022, 9:24 AM	25	8	12	18	01	2nd 2022, 9:24 AM	2	02	2022	44563	9:24 AM	0,3916666667	1/2/22 9:24
15	January 2nd 2022, 9:22 AM	25	8	12	18	01	2nd 2022, 9:22 AM	2	02	2022	44563	9:22 AM	0,3902777778	1/2/22 9:22
16	January 1st 2022, 12:08 PM	26	8	12	18	01	1st 2022, 12:08 PM	1	01	2022	44562	12:08 PM	0,5055555556	1/1/22 12:08
17	January 1st 2022, 12:08 PM	26	8	12	18	01	1st 2022, 12:08 PM	1	01	2022	44562	12:08 PM	0,5055555556	1/1/22 12:08
18	January 1st 2022, 12:07 PM	26	8	12	18	01	1st 2022, 12:07 PM	1	01	2022	44562	12:07 PM	0,5048611111	1/1/22 12:07
19	January 1st 2022, 12:07 PM	26	8	12	18	01	1st 2022, 12:07 PM	1	01	2022	44562	12:07 PM	0,5048611111	1/1/22 12:07
20	January 7th 2022, 4:27 PM	25	8	12	18	01	7th 2022, 4:27 PM	7	07	2022	44568	4:27 PM	0,6854166667	1/7/22 16:27
21	January 7th 2022, 4:26 PM	25	8	12	18	01	7th 2022, 4:26 PM	7	07	2022	44568	4:26 PM	0,6847222222	1/7/22 16:26
22		Zahl	Zahl	Zahl	Zahl	Text	Text	Text	Text	Text	Zahl	Text	Zahl	TT.MM.JJJJ hh:mm
23	Formel für Einzelzellenbezug*
24	Bezugszellen
25	Einzelne Berechnungsschritte
26	* alle Berechnungsschritte in dieser Formel beziehen sich nur noch auf die Zelle A2, sprich die Berechnungen der Zwischenspalten B-M werden alle als Ausdruck ihrer Berechnung aus A2 ausgegeben
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100