How to convert readings of every 15 minutes to one a day

[caralb]

I HAVE THIS TABLE:

2016-01-01 00:00:00	501.1322
2016-01-01 00:15:00	501.1432
2016-01-01 00:30:00	501.1235
2016-01-01 00:45:00	501.1046
2016-01-01 01:00:00	501.1276
2016-01-01 01:15:00	501.1499
2016-01-01 01:30:00	501.1407
2016-01-01 01:45:00	501.1447
2016-01-01 02:00:00	501.1361
2016-01-01 02:15:00	501.1318
2016-01-01 02:30:00	501.159
2016-01-01 02:45:00	501.1746
2016-01-01 03:00:00	501.1606
2016-01-01 03:15:00	501.145
2016-01-01 03:30:00	501.1512
2016-01-01 03:45:00	501.1656
2016-01-01 04:00:00	501.1748
2016-01-01 04:15:00	501.2027
2016-01-01 04:30:00	501.1875
2016-01-01 04:45:00	501.1583
2016-01-01 05:00:00	501.1706
2016-01-01 05:15:00	501.2023
2016-01-01 05:30:00	501.2142
2016-01-01 05:45:00	501.187
2016-01-01 06:00:00	501.1858
2016-01-01 06:15:00	501.1862
2016-01-01 06:30:00	501.1941
2016-01-01 06:45:00	501.2324
2016-01-01 07:00:00	501.2255
2016-01-01 07:15:00	501.1902
2016-01-01 07:30:00	501.2071
2016-01-01 07:45:00	501.2401
2016-01-01 08:00:00	501.2562
2016-01-01 08:15:00	501.2178
2016-01-01 08:30:00	501.2023
2016-01-01 08:45:00	501.2183
2016-01-01 09:00:00	501.2467
2016-01-01 09:15:00	501.2579
2016-01-01 09:30:00	501.2495
2016-01-01 09:45:00	501.2348
2016-01-01 10:00:00	501.2403
2016-01-01 10:15:00	501.265
2016-01-01 10:30:00	501.2674
2016-01-01 10:45:00	501.2603
2016-01-01 11:00:00	501.2475
2016-01-01 11:15:00	501.2537
2016-01-01 11:30:00	501.2685
2016-01-01 11:45:00	501.2903
2016-01-01 12:00:00	501.2854
2016-01-01 12:15:00	501.268
2016-01-01 12:30:00	501.2832
2016-01-01 12:45:00	501.305
2016-01-01 13:00:00	501.3136
2016-01-01 13:15:00	501.3031
2016-01-01 13:30:00	501.2968
2016-01-01 13:45:00	501.2967
2016-01-01 14:00:00	501.3072
2016-01-01 14:15:00	501.3211
2016-01-01 14:30:00	501.3192
2016-01-01 14:45:00	501.3226
2016-01-01 15:00:00	501.3244
2016-01-01 15:15:00	501.3294
2016-01-01 15:30:00	501.3394
2016-01-01 15:45:00	501.3236
2016-01-01 16:00:00	501.3239
2016-01-01 16:15:00	501.3349
2016-01-01 16:30:00	501.3519
2016-01-01 16:45:00	501.3501
2016-01-01 17:00:00	501.3506
2016-01-01 17:15:00	501.3552
2016-01-01 17:30:00	501.3633
2016-01-01 17:45:00	501.3681
2016-01-01 18:00:00	501.3605
2016-01-01 18:15:00	501.3634
2016-01-01 18:30:00	501.3834
2016-01-01 18:45:00	501.3691
2016-01-01 19:00:00	501.3759
2016-01-01 19:15:00	501.3632
2016-01-01 19:30:00	501.3758
2016-01-01 19:45:00	501.3942
2016-01-01 20:00:00	501.3962
2016-01-01 20:15:00	501.3897
2016-01-01 20:30:00	501.399
2016-01-01 20:45:00	501.4101
2016-01-01 21:00:00	501.4022
2016-01-01 21:15:00	501.4007
2016-01-01 21:30:00	501.4123
2016-01-01 21:45:00	501.4044
2016-01-01 22:00:00	501.4194
2016-01-01 22:15:00	501.4293
2016-01-01 22:30:00	501.4376
2016-01-01 22:45:00	501.4217
2016-01-01 23:00:00	501.4305
2016-01-01 23:15:00	501.4445
2016-01-01 23:30:00	501.4419
2016-01-01 23:45:00	501.4388 What do I have to do to get on per day e.g 09:00:00AM

<colgroup><col width="149" style="width: 112pt;"> <col width="64" style="width: 48pt;"> <tbody> </tbody>

 

[Scott Huish]

Divide column B by 96 and format as [h]:mm:ss or AM/PM time

 

[JoeMo]

Not sure I understand what you want, but if it's to get the reading for a particular date and time (like say, 1/1/2016 at 9:00 AM), you can use a vlookup.

Excel Workbook
	A	B	C	D	E	F	G	H
1	1/1/2016 0:00	501.1322		Year	Month	Day	Time	Number
2	1/1/2016 0:15	501.1432		2016	1	1	9:00 AM	501.2467
3	1/1/2016 0:30	501.1235
4	1/1/2016 0:45	501.1046
5	1/1/2016 1:00	501.1276
6	1/1/2016 1:15	501.1499
7	1/1/2016 1:30	501.1407
8	1/1/2016 1:45	501.1447
9	1/1/2016 2:00	501.1361
10	1/1/2016 2:15	501.1318
11	1/1/2016 2:30	501.159
12	1/1/2016 2:45	501.1746
13	1/1/2016 3:00	501.1606
14	1/1/2016 3:15	501.145
15	1/1/2016 3:30	501.1512
16	1/1/2016 3:45	501.1656
17	1/1/2016 4:00	501.1748
18	1/1/2016 4:15	501.2027
19	1/1/2016 4:30	501.1875
20	1/1/2016 4:45	501.1583
21	1/1/2016 5:00	501.1706
22	1/1/2016 5:15	501.2023
23	1/1/2016 5:30	501.2142
24	1/1/2016 5:45	501.187
25	1/1/2016 6:00	501.1858
26	1/1/2016 6:15	501.1862
27	1/1/2016 6:30	501.1941
28	1/1/2016 6:45	501.2324
29	1/1/2016 7:00	501.2255
30	1/1/2016 7:15	501.1902
31	1/1/2016 7:30	501.2071
32	1/1/2016 7:45	501.2401
33	1/1/2016 8:00	501.2562
34	1/1/2016 8:15	501.2178
35	1/1/2016 8:30	501.2023
36	1/1/2016 8:45	501.2183
37	1/1/2016 9:00	501.2467
38	1/1/2016 9:15	501.2579
Sheet1

 

[caralb]

Not sure I understand what you want, but if it's to get the reading for a particular date and time (like say, 1/1/2016 at 9:00 AM), you can use a vlookup.
Sheet1

	A	B	C	D	E	F	G	H
1	1/1/2016 0:00	501.1322		Year	Month	Day	Time	Number
2	1/1/2016 0:15	501.1432		2016	1	1	9:00 AM	501.2467
3	1/1/2016 0:30	501.1235
4	1/1/2016 0:45	501.1046
5	1/1/2016 1:00	501.1276
6	1/1/2016 1:15	501.1499
7	1/1/2016 1:30	501.1407
8	1/1/2016 1:45	501.1447
9	1/1/2016 2:00	501.1361
10	1/1/2016 2:15	501.1318
11	1/1/2016 2:30	501.159
12	1/1/2016 2:45	501.1746
13	1/1/2016 3:00	501.1606
14	1/1/2016 3:15	501.145
15	1/1/2016 3:30	501.1512
16	1/1/2016 3:45	501.1656
17	1/1/2016 4:00	501.1748
18	1/1/2016 4:15	501.2027
19	1/1/2016 4:30	501.1875
20	1/1/2016 4:45	501.1583
21	1/1/2016 5:00	501.1706
22	1/1/2016 5:15	501.2023
23	1/1/2016 5:30	501.2142
24	1/1/2016 5:45	501.187
25	1/1/2016 6:00	501.1858
26	1/1/2016 6:15	501.1862
27	1/1/2016 6:30	501.1941
28	1/1/2016 6:45	501.2324
29	1/1/2016 7:00	501.2255
30	1/1/2016 7:15	501.1902
31	1/1/2016 7:30	501.2071
32	1/1/2016 7:45	501.2401
33	1/1/2016 8:00	501.2562
34	1/1/2016 8:15	501.2178
35	1/1/2016 8:30	501.2023
36	1/1/2016 8:45	501.2183
37	1/1/2016 9:00	501.2467
38	1/1/2016 9:15	501.2579

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 108px;"><col style="width: 71px;"><col style="width: 64px;"><col style="width: 89px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 60px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula H2 =VLOOKUP(DATE(D2,E2,F2)+MOD(G2,1),$A$1:$B$96,2,0) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

JoeMo

I did it, but I got

#N/A

<colgroup><col width="137" style="width: 103pt;"> <tbody> </tbody>

I don't know what I am doing wrong.