Decrementing a Time value?

[vbeginner]

How can I subtract 00:00:01 from , say 00:10:45 ?

[Buzby]

Look in the help at DateAdd command; I can't test it right now but it should be something like;

NewTime = DateAdd("s",-1,OldTime)

[vbeginner]

Thanks for the help!

[Serge]

You also can substruct dates like you substruct numbers:

Private Sub Command1_Click()
    Dim datFirst As Date
    Dim datSecond As Date

    datFirst = #12:10:45 AM#
    datSecond = #12:00:01 AM#

    datFirst = datFirst - datSecond
    MsgBox datFirst
End Sub