how to subtract time?

[vinzpom]

how to subtract 75 sec from 12:01 pm.?
please help. i really dont know what to do

 

[tedsmith]

NewTime=Dateadd("s",-75,#12:01#)
You can use variables for the numbers.Eg this subracts 75 sec from the time of day

dim a as integer
a=-75
Time=Dateadd("s",a,Time())

 

[vinzpom]

ok, ill try it immediately sir

 

[vinzpom]

would datediff work as well?
thanks

 

[vb5prgrmr]

DateDiff is the difference between two dates. DateAdd is one date added or subtracted from by a given number based upon the parameter (seconds, minutes, hours...).

Good Luck

 

[vinzpom]

thanks for clearing up things vb5prgrmr.
one more thing..

how do i delete my old threads on this site?

 

[vb5prgrmr]

That you would have to take up with one of the admins of this site....

Good Luck

 

[vinzpom]

thank you vb5prgrmr.