time calculation

#1

Hello

I want to add a calculation to a query that calculates between a start
time and end time in minutes. There will be times where the start time
is before midnight and the end time after midnight. ie. start time 23:00
and end time 02:00 = 180 minutes

Thank you,
David

#2

The DateDiff function will do this for you very easily. Check it out in Help
file.

--

Ken Snell
<MS ACCESS MVP>

"David" <dfizer (AT) rochester (DOT) rr.com> wrote

Quote:

Hello

I want to add a calculation to a query that calculates between a start
time and end time in minutes. There will be times where the start time is
before midnight and the end time after midnight. ie. start time 23:00 and
end time 02:00 = 180 minutes

Thank you,
David

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

time calculation

comp.database.ms-access comp.database.ms-access

time calculation - 02-21-2007 , 08:28 PM

Re: time calculation - 02-24-2007 , 02:53 PM