Time duration between two dates/times.

[hooi]

I've two dates/times in mm/dd/yyy hh:mm format.

TimeA: 2/7/2003 2:00am
TimeB: 2/8/2003 4:00am

I have field (date field) and do a simple TimeB - TimeA, the result is 2:00 which is wrong as the second date/time is over a day already.

Any suggestion what I should do? Thanks....

 

[Mile-O]

Lookup the DateDiff() function.

 

[hooi]

Thanks...