Subtracting two Dates, converting to seconds

[radonc]

I have read the FAQs for elapsed time but am caught at an intermediate step. I have two DateTimeValues, i.e.

2/21/2002 9:28:32AM
2/27/2002 2:14:44PM

when i subtract them, it returns "6.20"

I would like for it to return the total number of seconds between the two dates, so that i can plug it into the DD:HH:MM:SS formula. Any suggestions? Thanks.

 

[MJSQA]

This is giving you the number of days between the times. Multiply by the number of seconds in a day and you get your answer.

 

[radonc]

its official . . . . . i am a moron.