<div>
Use the Format function.<br />
<br />
? format(time,&quot;hh:nn:ss AMPM&quot;)<br />
09:50:33 PM<br />
? format(time,&quot;hh:nn:ss&quot;)<br />
21:50:47<br />

</div>


Use the Format function.

? format(time,"hh:nn:ss AMPM")
09:50:33 PM
? format(time,"hh:nn:ss")
21:50:47


<div>
Date, Time and Now are probably what you want, but also take a look at the following functions: Year, Month, Day, Hour, Minute and Second.
</div>


Date, Time and Now are probably what you want, but also take a look at the following functions: Year, Month, Day, Hour, Minute and Second.

<div>
Thank you everyone,soosairaj,emoreau<wbr /> &amp;<br />
KDavid.
</div>


Thank you everyone,soosairaj,emoreau &
KDavid.

<div>
Also does anyone know a bit of code that would allow the subtraction of time over midnight.<br />
E.g From 1300 (PM) Thursday 9 March to<br />
&nbsp;0200 (AM) Friday 10 March.<br />
<br />
The Code will tell the difference between the two in days,hours &amp;&nbsp;minutes.<br />
<br />
Thanks<br />
Dave Steers
</div>


Also does anyone know a bit of code that would allow the subtraction of time over midnight.
E.g From 1300 (PM) Thursday 9 March to
 0200 (AM) Friday 10 March.

The Code will tell the difference between the two in days,hours & minutes.

Thanks
Dave Steers

<div>
DAMM !!<br />
I meant to Give the points to emoreau,<br />
(sorry soosairaj).<br />
My mistake.<br />
<br />
emoreau I will post you the points in another question labled <br />
&quot;Points for emoreau&quot;<br />
sorry for this inconvienience.<br />
Thanks<br />

</div>


DAMM !!
I meant to Give the points to emoreau,
(sorry soosairaj).
My mistake.

emoreau I will post you the points in another question labled
"Points for emoreau"
sorry for this inconvienience.
Thanks


<div>
&gt;&gt;Also does anyone know a bit of code that would allow the subtraction of time over midnight.&lt;&lt;<br />
Take a look at the DateDiff function.
</div>


>>Also does anyone know a bit of code that would allow the subtraction of time over midnight.<<
Take a look at the DateDiff function.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I was wondering if anyone could help me.<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I want to know how to get the current computer time and date,<br />
in both 24 hr format or showing &quot;AM/PM&quot;<br />
<br />
<br />
Thanks<br />
Dave Steers
</div>
</div>


Hi,
I was wondering if anyone could help me.
	I want to know how to get the current computer time and date,
in both 24 hr format or showing "AM/PM"


Thanks
Dave Steers

Getting Computers Date &amp; Time

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Getting Computers Date &amp; Time

Getting Computers Date & Time