date manipulation question

[softwareguy74]

Hi,

This should be a simple one for you seasoned professionals out there...

I have the following code:

EndTime = DateAdd("s", TimeOut, Now)

That returns:

08/25/2000 4:18:08 PM

What I then need to do is to convert EndTime into an Integer and so that it only shows the 2 digit seconds, such as:

08

Thanks in advance!

Dan

[DrewDog_21]

Use the Second function

Dim MyTime As Integer

MyTime = Second(EndTime)