<div>
thank you, that makes sense!
</div>


<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I have a database that uses a few fields that is of data type Date/Time, and want to use is as a time field, such as 6:13.<br />
I am &nbsp;able to display as such within Access, but when I export to Excel, the whole info comes, date, time with AM/PM.<br />
How can I just export the way I am displaying?<br />
Please advise.
</div>
</div>


Dear Experts,

I have a database that uses a few fields that is of data type Date/Time, and want to use is as a time field, such as 6:13.
I am  able to display as such within Access, but when I export to Excel, the whole info comes, date, time with AM/PM.
How can I just export the way I am displaying?
Please advise.

Accesss export with formatting

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.