Please read the following table in HTML format from a webpage and then answer the question in detail according to the table. Each table cell is defined by a <td> and a </td> tag. Each table row starts with a <tr> and ends with a </tr> tag. 'rowspan=m' and 'colspan=n' represents a cell spaning over 'm' rows and 'n' columns.

Webpage title:
Swimming at the 2012 Summer Olympics – Men's 100 metre freestyle
Table title:
Final
Table:
<table id='hittask' contenteditable='False'>
<tr> <th colspan=1 rowspan=1 > Rank </th><th colspan=1 rowspan=1 > Lane </th><th colspan=1 rowspan=1 > Name </th><th colspan=1 rowspan=1 > Nationality </th><th colspan=1 rowspan=1 > Time </th><th colspan=1 rowspan=1 > Notes </th></tr>
<tr> <td colspan=1 rowspan=1 >  </td><td colspan=1 rowspan=1 > 5 </td><td class="highlighted"  colspan=1 rowspan=1 > Nathan Adrian </td><td colspan=1 rowspan=1 > United States </td><td class="highlighted"  colspan=1 rowspan=1 > 47.52 </td><td colspan=1 rowspan=1 >  </td></tr>
<tr> <td colspan=1 rowspan=1 >  </td><td colspan=1 rowspan=1 > 4 </td><td class="highlighted"  colspan=1 rowspan=1 > James Magnussen </td><td colspan=1 rowspan=1 > Australia </td><td class="highlighted"  colspan=1 rowspan=1 > 47.53 </td><td colspan=1 rowspan=1 >  </td></tr>
<tr> <td colspan=1 rowspan=1 >  </td><td colspan=1 rowspan=1 > 7 </td><td colspan=1 rowspan=1 > Brent Hayden </td><td colspan=1 rowspan=1 > Canada </td><td colspan=1 rowspan=1 > 47.80 </td><td colspan=1 rowspan=1 >  </td></tr>
<tr> <td colspan=1 rowspan=1 > 4 </td><td colspan=1 rowspan=1 > 1 </td><td colspan=1 rowspan=1 > Yannick Agnel </td><td colspan=1 rowspan=1 > France </td><td colspan=1 rowspan=1 > 47.84 </td><td colspan=1 rowspan=1 >  </td></tr>
<tr> <td colspan=1 rowspan=1 > 5 </td><td colspan=1 rowspan=1 > 6 </td><td colspan=1 rowspan=1 > Sebastiaan Verschuren </td><td colspan=1 rowspan=1 > Netherlands </td><td colspan=1 rowspan=1 > 47.88 </td><td colspan=1 rowspan=1 >  </td></tr>
<tr> <td colspan=1 rowspan=1 > 6 </td><td colspan=1 rowspan=1 > 2 </td><td colspan=1 rowspan=1 > César Cielo </td><td colspan=1 rowspan=1 > Brazil </td><td colspan=1 rowspan=1 > 47.92 </td><td colspan=1 rowspan=1 >  </td></tr>
<tr> <td colspan=1 rowspan=1 > 7 </td><td colspan=1 rowspan=1 > 3 </td><td colspan=1 rowspan=1 > Hanser García </td><td colspan=1 rowspan=1 > Cuba </td><td colspan=1 rowspan=1 > 48.04 </td><td colspan=1 rowspan=1 > =NR </td></tr>
<tr> <td colspan=1 rowspan=1 > 8 </td><td colspan=1 rowspan=1 > 8 </td><td colspan=1 rowspan=1 > Nikita Lobintsev </td><td colspan=1 rowspan=1 > Russia </td><td colspan=1 rowspan=1 > 48.44 </td><td colspan=1 rowspan=1 >  </td></tr>
</table>
Question:
What was Adrian’s final time and what lead did that give him?
Answer:
Adrian finished in 47.52 to edge out Magnussen by a second (0.01).