Time field for calculating past midnight

#1 November 3rd, 2005, 04:09 AM

There were some instructions on here but I didn't understand how to put the
date and time to calculate total minutes between the interval. I have two
fields in my data base. Time and then date for a set of 6 different numbers.
I want to have access calculate the differences between two times that may
occur on different dates. How do I do this?

#2 November 3rd, 2005, 05:12 AM

You can add the date field and the time field together, and then use the
DateDiff function to calculate the difference between two date/time values.

ElapsedMinutes = DateDiff("n", [DateField1] + [TimeField1], [DateField2] +
[TimeField2])
--

Ken Snell
MS ACCESS MVP

"Tina N." wrote in message
...
There were some instructions on here but I didn't understand how to put
the
date and time to calculate total minutes between the interval. I have two
fields in my data base. Time and then date for a set of 6 different
numbers.
I want to have access calculate the differences between two times that may
occur on different dates. How do I do this?

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Memo Field	Sam	General Discussion	12	November 10th, 2005 09:16 PM
Time Zone suggestions for Outlook Calendar	Ben Knox	Calendar	2	October 20th, 2005 03:42 PM
Please Help! Ref Article ID 210504	Telobamipada	New Users	8	May 9th, 2005 01:09 PM
Design help, please	SillySally	Using Forms	27	March 6th, 2005 04:11 AM
Use first record found in expression?	CASJAS	Running & Setting Up Queries	17	July 22nd, 2004 09:21 PM