Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Queries > Subtracting tim...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 41184 of 43104
Post > Topic >>

Subtracting time for lunch from hours worked

by =?Utf-8?B?U2hhd24=?= <Shawn@[EMAIL PROTECTED] > Aug 5, 2008 at 12:29 PM

I am using MS Access 2007.  I have a start field and a stop field and a
lunch 
field.
Start field and stop field are set up as short time (military).  Lunch is 
set up a a number.  Currently I am getting the minutes worked by using
this 
formula Minutes: DateDiff("n",[Begin],[End])

Then I take the lunch field and calculate it using this formula Expr1: 
[Service]![Lunch]*60

Then to get the total minutes I use this formula Expr2: [Minutes]-[Expr1]

To get the total hours worked I use this formula Expr3: [Expr2]/60

Is there an easier way to do this?

Thanks
 




 2 Posts in Topic:
Subtracting time for lunch from hours worked
=?Utf-8?B?U2hhd24=?= <  2008-08-05 12:29:00 
Re: Subtracting time for lunch from hours worked
Lord Kelvan <the_iddio  2008-08-05 13:38:17 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Nov 20 22:07:28 CST 2008.