<div>
<br />
I'm prety sure the Hour(sometime) and Minute(sometime) <br />
functions return their answers in Military time as well. &nbsp;You may find those useful in some circumstances.<br />

</div>



I'm prety sure the Hour(sometime) and Minute(sometime)
functions return their answers in Military time as well.  You may find those useful in some circumstances.


<div>
Hi doe5,<br />
<br />
You can also use:<br />
=format(MyTime,&quot;hh:MM&quot;)<br />
<br />
or what ever format that suits your needs.<br />
<br />
HTH,<br />
<br />
Nosterdamus
</div>


Hi doe5,

You can also use:
=format(MyTime,"hh:MM")

or what ever format that suits your needs.

HTH,

Nosterdamus

<div>
Thanks. Sorry it took so long to respond to your answer.
</div>


Thanks. Sorry it took so long to respond to your answer.

<div>
<div class="content wysiwyg-content">
How do I convert the times in my tables to military time?
</div>
</div>


How do I convert the times in my tables to military time?

Military time

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.