Deducting date and time from another date and time!

[somnia]

I am trying to perform the following calculation. On a car hire form I need to calculate the length, in days and hours, of the car hire by deducting one set of date and time ('car_collected') from the return date ('date_returned'). I need to display how many days and hours the car was hired for. I've tried Trunc and Mod but not sure I am getting formula correct as weird answers returned, eg 731305.0

Any help very appreciated!!

Thanks

mike@somnia

 

[paulbent]

Subtracting two time fields returns the elapsed time (a numeric value not a time) in hundredths of seconds.

Subtracting two date fields returns the elapsed time in days.

It gets quite complicated when the start and end times span two or more days. There's a sample of these calcs at

http://www.xpertss.com

Follow the Free Downloads link and search for Timelap.zip.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk