dget??

[ajrinehart]

I'm trying to extract data out of a database using dget. How do I create a criteria that uses date and time? The database is.....

<table width="296" border="0" cellpadding="0" cellspacing="0"><col style="mso-width-source:userset;mso-width-alt:3803;width:78pt" width="104"> <col style="width:48pt" width="64" span="3"> <tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:78pt" width="104" height="17">Date and Time</td> <td style="width:48pt" width="64"> I</td> <td style="width:48pt" width="64">Type</td> <td style="width:48pt" width="64">pressure</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" height="17" align="right">1/1/08 0:00</td> <td align="right">4</td> <td>FM-12</td> <td align="right">1021.7</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" height="17" align="right">1/1/08 1:00</td> <td align="right">4</td> <td>FM-15</td> <td align="right">1021.5</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" height="17" align="right">1/1/08 2:00</td> <td align="right">4</td> <td>FM-15</td> <td align="right">1021.3</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" height="17" align="right">1/1/08 3:00</td> <td align="right">4</td> <td>FM-15</td> <td align="right">1021.2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" height="17" align="right">1/1/08 4:00</td> <td align="right">4</td> <td>FM-15</td> <td align="right">1020.6</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" height="17" align="right">1/1/08 5:00</td> <td align="right">4</td> <td>FM-15</td> <td align="right">1019.5</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" height="17" align="right">1/1/08 6:00</td> <td align="right">4</td> <td>FM-15</td> <td align="right">1018.9</td> </tr> </tbody></table> and so on.....

I want to export the pressure for each of these times and place in another column (see following) and be able to interpolate to 15 min intervals...
<table width="196" height="151" border="0" cellpadding="0" cellspacing="0"><col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="width:48pt" width="64"> <tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:82pt" width="109" height="17">
Date and Time</td> <td style="width:48pt" width="64">pressure</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17" align="right">5/1/09 12:00 AM</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17" align="right">5/1/09 12:15 AM</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17" align="right">5/1/09 12:30 AM</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17" align="right">5/1/09 12:45 AM</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17" align="right">5/1/09 1:00 AM</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17" align="right">5/1/09 1:15 AM</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17" align="right">5/1/09 1:30 AM</td> <td>
</td> </tr> </tbody></table>

 

[shg]

Welcome to the board.

Ignoring that the year is different in the examples, why can't you use a simple VLOOKUP?

Or if the data is at 1-minute intervals, add a column (=MINUTE(A2)) and autofilter for 15?