Datetime manipulation

[Rosco5737]

Hi all, I have been racking my brain on this for a couple days now and was looking for a little insight. I am working with a Access database through Microsofts ODBC using the Microsoft.ODBC.dll. There are two columns in that database, Start time and finish time, that are type DateTime. All I want to do is create another column (results) where I can store the difference of the start time and finish time columns. Doing this:
Results.Expression = "FINISH_TIME - START_TIME" or this
Results.Expression = "FINISH_TIME.Subtract(START_TIME)"
do not work. The first method gives an error that the "-" operator cannot be used with type DateTime. The second gives me this error: The expression contains undefined function call FINISH_TIME.Subtract(). Am I going about this the wrong way? Any thoughts, suggestions? Thanks

 

[boes]

I dont know that you have to do it this way but in Excel I know a date/time is a number. For your example I should first format tha start and finish time into a integer, make the subtraction and then change the result back into a time.