Date and Time

[cfer]

Is it possible to be able to subtract a date and time from another, then be able to add these times together.

ie 19:15 hrs on 2/04/03 take away 18:00 hrs on 1/4/02, the result I would look for is 24:15

If it is not possible, how would you link it to excel to do the calculation, then have the answer back in Access

Thanks cfer

 

[mdmilner]

Yes it is.

http://www.mvps.org/access/datetime/date0009.htm