I think what I want is simple?
I have a Start Time and a Finish Time and I want to know the expression ina
query that returns the amount of time between.
i.e
Start 09.00 Finish 17.15 What is the expression to return 8.15?
Access Date/Time fields are best viewed as points in time (actually they're
stored as double float numbers, counts of days and fractions of a day since
midnight, December 30, 1899. As such, 9 am is actually stored as 0.375 and
corresponds to #12/30/1899 09:00:00#; if you will ever have a period of time
that spans midnight, this can become an issue. If that's the case you should
store the date AND TIME together in the same field; this will let you more
easily measure the graveyard shift from 11:30pm (April 27) to 5:30am (April
28).
To get the amount of time in minutes (or seconds, or years, or anything in
between) you can use the DateDiff function, e.g. DateDiff("n", [Start Time],
[Finish Time]). (It's "n" for miNutes, "m" is Months). You can display 495
minutes as 8.15 using an expression like
DateDiff("n", [Start Time], [Finish Time])\60 & "." & Format(DateDiff("n",
[Start Time], [Finish Time]) MOD 60, "00")
