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

C

caralb

New Member
Joined
Oct 26, 2017
Messages
6
I HAVE THIS TABLE:

[TABLE="width: 160"]
<colgroup><col width="149" style="width: 112pt;"> <col width="64" style="width: 48pt;"> <tbody>[TR]
[TD="width: 149, bgcolor: transparent"]2016-01-01 00:00:00[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]501.1322[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 00:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1432[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 00:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1235[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 00:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1046[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 01:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1276[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 01:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1499[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 01:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1407[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 01:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1447[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 02:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1361[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 02:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1318[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 02:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.159[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 02:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1746[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 03:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1606[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 03:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.145[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 03:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1512[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 03:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1656[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 04:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1748[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 04:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2027[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 04:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1875[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 04:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1583[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 05:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1706[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 05:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2023[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 05:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2142[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 05:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.187[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 06:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1858[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 06:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1862[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 06:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1941[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 06:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2324[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 07:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2255[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 07:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1902[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 07:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2071[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 07:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2401[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 08:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2562[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 08:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2178[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 08:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2023[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 08:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2183[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 09:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2467[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 09:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2579[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 09:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2495[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 09:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2348[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 10:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2403[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 10:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.265[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 10:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2674[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 10:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2603[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 11:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2475[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 11:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2537[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 11:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2685[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 11:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2903[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 12:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2854[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 12:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.268[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 12:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2832[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 12:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.305[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 13:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3136[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 13:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3031[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 13:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2968[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 13:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2967[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 14:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3072[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 14:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3211[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 14:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3192[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 14:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3226[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 15:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3244[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 15:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3294[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 15:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3394[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 15:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3236[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 16:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3239[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 16:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3349[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 16:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3519[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 16:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3501[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 17:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3506[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 17:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3552[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 17:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3633[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 17:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3681[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 18:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3605[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 18:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3634[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 18:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3834[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 18:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3691[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 19:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3759[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 19:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3632[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 19:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3758[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 19:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3942[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 20:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3962[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 20:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3897[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 20:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.399[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 20:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4101[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 21:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4022[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 21:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4007[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 21:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4123[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 21:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4044[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 22:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4194[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 22:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4293[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 22:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4376[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 22:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4217[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 23:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4305[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 23:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4445[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 23:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4419[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 23:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4388

What do I have to do to get on per day e.g 09:00:00AM[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sort by date Sort by votes
Divide column B by 96 and format as [h]:mm:ss or AM/PM time
 
Last edited:
Upvote 0
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
ABCDEFGH
11/1/2016 0:00501.1322YearMonthDayTimeNumber
21/1/2016 0:15501.14322016119:00 AM501.2467
31/1/2016 0:30501.1235
41/1/2016 0:45501.1046
51/1/2016 1:00501.1276
61/1/2016 1:15501.1499
71/1/2016 1:30501.1407
81/1/2016 1:45501.1447
91/1/2016 2:00501.1361
101/1/2016 2:15501.1318
111/1/2016 2:30501.159
121/1/2016 2:45501.1746
131/1/2016 3:00501.1606
141/1/2016 3:15501.145
151/1/2016 3:30501.1512
161/1/2016 3:45501.1656
171/1/2016 4:00501.1748
181/1/2016 4:15501.2027
191/1/2016 4:30501.1875
201/1/2016 4:45501.1583
211/1/2016 5:00501.1706
221/1/2016 5:15501.2023
231/1/2016 5:30501.2142
241/1/2016 5:45501.187
251/1/2016 6:00501.1858
261/1/2016 6:15501.1862
271/1/2016 6:30501.1941
281/1/2016 6:45501.2324
291/1/2016 7:00501.2255
301/1/2016 7:15501.1902
311/1/2016 7:30501.2071
321/1/2016 7:45501.2401
331/1/2016 8:00501.2562
341/1/2016 8:15501.2178
351/1/2016 8:30501.2023
361/1/2016 8:45501.2183
371/1/2016 9:00501.2467
381/1/2016 9:15501.2579
Sheet1
 
Upvote 0
JoeMo said:
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

ABCDEFGH
YearMonthDayTimeNumber

<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>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]1[/TD]
[TD="align: right"]1/1/2016 0:00[/TD]
[TD="align: right"]501.1322[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]2[/TD]
[TD="align: right"]1/1/2016 0:15[/TD]
[TD="align: right"]501.1432[/TD]

[TD="align: right"]2016[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]501.2467[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]3[/TD]
[TD="align: right"]1/1/2016 0:30[/TD]
[TD="align: right"]501.1235[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]4[/TD]
[TD="align: right"]1/1/2016 0:45[/TD]
[TD="align: right"]501.1046[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]5[/TD]
[TD="align: right"]1/1/2016 1:00[/TD]
[TD="align: right"]501.1276[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]6[/TD]
[TD="align: right"]1/1/2016 1:15[/TD]
[TD="align: right"]501.1499[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]7[/TD]
[TD="align: right"]1/1/2016 1:30[/TD]
[TD="align: right"]501.1407[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]8[/TD]
[TD="align: right"]1/1/2016 1:45[/TD]
[TD="align: right"]501.1447[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]9[/TD]
[TD="align: right"]1/1/2016 2:00[/TD]
[TD="align: right"]501.1361[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]10[/TD]
[TD="align: right"]1/1/2016 2:15[/TD]
[TD="align: right"]501.1318[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]11[/TD]
[TD="align: right"]1/1/2016 2:30[/TD]
[TD="align: right"]501.159[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]12[/TD]
[TD="align: right"]1/1/2016 2:45[/TD]
[TD="align: right"]501.1746[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]13[/TD]
[TD="align: right"]1/1/2016 3:00[/TD]
[TD="align: right"]501.1606[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]14[/TD]
[TD="align: right"]1/1/2016 3:15[/TD]
[TD="align: right"]501.145[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]15[/TD]
[TD="align: right"]1/1/2016 3:30[/TD]
[TD="align: right"]501.1512[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]16[/TD]
[TD="align: right"]1/1/2016 3:45[/TD]
[TD="align: right"]501.1656[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]17[/TD]
[TD="align: right"]1/1/2016 4:00[/TD]
[TD="align: right"]501.1748[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]18[/TD]
[TD="align: right"]1/1/2016 4:15[/TD]
[TD="align: right"]501.2027[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]19[/TD]
[TD="align: right"]1/1/2016 4:30[/TD]
[TD="align: right"]501.1875[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]20[/TD]
[TD="align: right"]1/1/2016 4:45[/TD]
[TD="align: right"]501.1583[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]21[/TD]
[TD="align: right"]1/1/2016 5:00[/TD]
[TD="align: right"]501.1706[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]22[/TD]
[TD="align: right"]1/1/2016 5:15[/TD]
[TD="align: right"]501.2023[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]23[/TD]
[TD="align: right"]1/1/2016 5:30[/TD]
[TD="align: right"]501.2142[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]24[/TD]
[TD="align: right"]1/1/2016 5:45[/TD]
[TD="align: right"]501.187[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]25[/TD]
[TD="align: right"]1/1/2016 6:00[/TD]
[TD="align: right"]501.1858[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]26[/TD]
[TD="align: right"]1/1/2016 6:15[/TD]
[TD="align: right"]501.1862[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]27[/TD]
[TD="align: right"]1/1/2016 6:30[/TD]
[TD="align: right"]501.1941[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]28[/TD]
[TD="align: right"]1/1/2016 6:45[/TD]
[TD="align: right"]501.2324[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]29[/TD]
[TD="align: right"]1/1/2016 7:00[/TD]
[TD="align: right"]501.2255[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]30[/TD]
[TD="align: right"]1/1/2016 7:15[/TD]
[TD="align: right"]501.1902[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]31[/TD]
[TD="align: right"]1/1/2016 7:30[/TD]
[TD="align: right"]501.2071[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]32[/TD]
[TD="align: right"]1/1/2016 7:45[/TD]
[TD="align: right"]501.2401[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]33[/TD]
[TD="align: right"]1/1/2016 8:00[/TD]
[TD="align: right"]501.2562[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]34[/TD]
[TD="align: right"]1/1/2016 8:15[/TD]
[TD="align: right"]501.2178[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]35[/TD]
[TD="align: right"]1/1/2016 8:30[/TD]
[TD="align: right"]501.2023[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]36[/TD]
[TD="align: right"]1/1/2016 8:45[/TD]
[TD="align: right"]501.2183[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]37[/TD]
[TD="align: right"]1/1/2016 9:00[/TD]
[TD="align: right"]501.2467[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]38[/TD]
[TD="align: right"]1/1/2016 9:15[/TD]
[TD="align: right"]501.2579[/TD]

</tbody>

Spreadsheet Formulas
CellFormula
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
Click to expand...

JoeMo

I did it, but I got [TABLE="width: 103"]
<colgroup><col width="137" style="width: 103pt;"> <tbody>[TR]
[TD="width: 137, bgcolor: transparent, align: center"]#N/A[/TD]
[/TR]
</tbody>[/TABLE]
I don't know what I am doing wrong.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Count entry by time
Replies
3
Views
194
admvlad
A
B
  • Question Question
Excel Pivot Table to see the number of "Lost Calls"
Replies
0
Views
64
Bernie Galve
B
O
  • Solved
Travel Duration allowing for more than one day and different time zones
Replies
7
Views
147
myall_blues
myall_blues
M
  • Question Question
Pivot table not showing as Numbers
Replies
1
Views
274
shift-del
shift-del
D
  • Question Question
Formula help needed for working with days and times.
Replies
0
Views
319
dshtesy
D

Forum statistics

Threads
1,223,912
Messages
6,175,339
Members
452,637
Latest member
Ezio2866

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top