Quote Originally Posted by thegreatone
Can anyone show me how to compare a date and time (that are hardcoded) with the current date and time ?
And then show the elapsed time in seconds ?

Any help is greatly appreciated.
Try this:
VB Code:
  1. Debug.print DateDiff("s", "04/18/2005 17:51", Now)