converting date/time into hours

[CJ]

I have 2 fields called open date & close date. I need to
get age.
age=close date-open date
The output should be in hours.(age = number of hours)

 

[Allen Browne]

Create a query into this table.

In a fresh column of the Field row of the query design grid, enter:
Hours: DateDiff("h", [open date], [close date])

Note that this expression looks at the whole hours only. To deal with
fractions of hours, use:
Hours: DateDiff("n", [open date], [close date]) / 60