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

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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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
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

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

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

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