Time Format hh:nn:ss in access
<p>We have reports run for us that shows the amount of time a user has been logged in. The report is in excel and shows the cell format as text, the time shown in the cell is in this format 08:10:31 </p>

<p>When I import this to access it shows as a 5 digit number (e.g 20326)</p>

<p>How do I get access to show it in the same format that its in excel?</p>

<p>I have tried changing the table format in access to hh:nn:ss but then the cell shows as blank.</p>

<p>Help</p>