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

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

O
  • Solved
Travel Duration allowing for more than one day and different time zones
Replies
7
Views
142
myall_blues
myall_blues
M
  • Question Question
Pivot table not showing as Numbers
Replies
1
Views
266
shift-del
shift-del
J
  • Question Question
Finding Numbers from a Column Using Target Numbers
2
Replies
11
Views
414
Cubist
Cubist
A
  • Question Question
Need to convert days, hours, minutes and second text into hh:mm:ss
Replies
7
Views
851
Aadya
A
J
  • Solved
Sorting a Lot of data into multiple sheets (up to 200k lines)
Replies
4
Views
310
JMWh1t3
J

Forum statistics

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

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