>Hi Michel,
>
>SECONDS() only returns the number of seconds passed since midnight.
>
>Using DATETIME() should solve this problem.
>
>

>dtStartTime   = {04/07/2001 11:59:59 PM}
>dtEndTime     = {05/07/2001 12:00:01 AM}
>nTotalSeconds = dtEndTime - dtStartTime
>

>
>The above example will return 2 seconds.
>
>Please note that I'm using a BRITISH date format.

Yes, I thought about that after I sent this message. Thanks <s>