<div>
You can force AM:PM as below<br />
<br />
Regards<br />
<br />
dave<br />

<pre><code id="code-7985628">Dim x As Date

Selection = Format(Date, &quot;mm-dd-yyyy&quot;) &amp; &quot;--&quot; &amp; Format(Time, &quot;hh:mm:ss AMPM&quot;)</code></pre>
</div>


You can force AM:PM as below

Regards

dave


Dim x As Date

Selection = Format(Date, "mm-dd-yyyy") & "--" & Format(Time, "hh:mm:ss AMPM")

<div>
Yes, I tried using Format(Time, &quot;hh:mm:ss ampm&quot;) but it still returns the time in military time format.<br />
<br />
I have the same OS Regional settings on my pc at home and Selection=Time returns the time in hh:mm:ss AMPM but I run Office 2007 at home and 2010 at work but I can find no setting in 2010 that appears to be forcing military time.<br />
<br />

</div>


Yes, I tried using Format(Time, "hh:mm:ss ampm") but it still returns the time in military time format.

I have the same OS Regional settings on my pc at home and Selection=Time returns the time in hh:mm:ss AMPM but I run Office 2007 at home and 2010 at work but I can find no setting in 2010 that appears to be forcing military time.



<div>
Oh i should have mentioned,<br />
Macro1 and Macro2 are the same except for using Dateserial and Timeserial<br />
I just wanted to point out the value of those functions because it makes it easy to leave out the seconds if you don't actually want them. It also makes it easy to get dates such as last date of previous month, Last quarter, and things like that.<br />
<br />
Best Regards
</div>


Oh i should have mentioned,
Macro1 and Macro2 are the same except for using Dateserial and Timeserial
I just wanted to point out the value of those functions because it makes it easy to leave out the seconds if you don't actually want them. It also makes it easy to get dates such as last date of previous month, Last quarter, and things like that.

Best Regards

<div>
<div class="content wysiwyg-content">
Hi, my excel code returns the time in military time - my OS is not set to military time, how can I take the time function out of returning military time?<br />
<br />
I am using Excel 2010<br />
<br />
<br />
Thanks much,<br />
<br />
<br />
<br />
Dim x As Date<br />
<br />
x = Format(Date, &quot;mm-dd-yyyy&quot;)<br />
<br />
<br />
Selection = x &amp;&nbsp;&quot;---&quot; &amp;&nbsp;Time<br />
<br />

</div>
</div>


Hi, my excel code returns the time in military time - my OS is not set to military time, how can I take the time function out of returning military time?

I am using Excel 2010


Thanks much,



Dim x As Date

x = Format(Date, "mm-dd-yyyy")


Selection = x & "---" & Time



Excel vba question

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.