p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Time Difference


Message #1 by pmcmillin@m... on Mon, 11 Jun 2001 11:04:43 -0500

I am needing the formula to calculate the difference in hrs and 

minutes.  This is being used as a time clock.  Where an employee types in 

their time they arrive, amount of time taken for lunch hr and the time they 

leave.  e.i.  8:00 am - 6:00 pm and 1 hr for lunch.  I need to know the 

number of hrs and minutes worked.







Pam McMillin

Systems Technician



Schlumberger - IPM Asset Management

500 W. Texas, Suite 500

P.O. Box 2726

Midland, TX 79702-2726

Office 915/571-4600

Cell 915/556-0749

Fax 915/571-4788

pmcmillin@m...

Message #2 by "Carl Schwarcz" <carl@s...> on Mon, 11 Jun 2001 10:16:50 -0700



Have a look at the DatePart function:



DatePart(interval, date[,firstdayofweek[, firstweekofyear]])



It would allow you extract the number of hours and minutes from a date

and do you calculation.



Alternativeley you can check out the DateDiff function:



DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])



Which allows you to subtract one date from the other...







-----Original Message-----

From: Pam McMillin [mailto:pmcmillin@m...] 

Sent: Monday, June 11, 2001 9:19 AM

To: Access

Subject: [access] Time Difference







I am needing the formula to calculate the difference in hrs and 

minutes.  This is being used as a time clock.  Where an employee types

in 

their time they arrive, amount of time taken for lunch hr and the time

they 

leave.  e.i.  8:00 am - 6:00 pm and 1 hr for lunch.  I need to know the 

number of hrs and minutes worked.







Pam McMillin

Systems Technician



Schlumberger - IPM Asset Management

500 W. Texas, Suite 500

P.O. Box 2726

Midland, TX 79702-2726

Office 915/571-4600

Cell 915/556-0749

Fax 915/571-4788

pmcmillin@m...










Message #3 by "John Ruff" <papparuff@c...> on Mon, 11 Jun 2001 15:02:12 -0700
Pam,



Go to Url

http://support.microsoft.com/support/kb/articles/Q130/5/14.asp?LN=EN-US&SD=g

n&FR=0&qry=Calculating%20and%20Displaying%20Date/Time%20Values&rnk=3&src=DHC

S_MSPSS_gn_SRCH&SPR=ACC97



It provides information and code on computing dates and times and is exactly

what you are looking for.



If you cannot  read the full Url above, go to www.Microsoft.com > Support >

Knowledgebase

Select Specific article ID number then type  Q13054 in the "My question is:"

block.



This is Microsoft Knowledgebase Article ID Q130514



John Ruff - The Eternal Optimist :)

 -----Original Message-----

From: 	Pam McMillin [mailto:pmcmillin@m...]

Sent:	Monday, June 11, 2001 9:19 AM

To:	Access

Subject:	[access] Time Difference





I am needing the formula to calculate the difference in hrs and

minutes.  This is being used as a time clock.  Where an employee types in

their time they arrive, amount of time taken for lunch hr and the time they

leave.  e.i.  8:00 am - 6:00 pm and 1 hr for lunch.  I need to know the

number of hrs and minutes worked.







Pam McMillin

Systems Technician



Schlumberger - IPM Asset Management

500 W. Texas, Suite 500

P.O. Box 2726

Midland, TX 79702-2726

Office 915/571-4600

Cell 915/556-0749

Fax 915/571-4788

pmcmillin@m...











  Return to Index