Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > TechHelp > Directory > Access > 15-Min Increments < Outer Joins | AutoTab >
Back to 15-Minute Increments    Comments List
Time Calculations In Query Upload Images   Link   Email  
Lydia ONeal 
I received the 15-minute increment video in response to my question from last week.  I had already seen this video, but was wanting to see the additional information you mentioned about calculating to the nearest quarter hour and removing breaks to get total time worked.  Can you provide me with what to review for this information.  It is not mentioned in the 15-minute increment video that I can see.  Thank you.
Richard Rost 
Did you watch the Extended Cut?
Lydia ONeal 
Richard, I appreciate you trying to answer my questions regarding calculating total work time.  Can you tell me what paid course I could do in order to get the answers I need.  Again, I want to know how to calculate a value from a clock in and a clock out time to nearest quarter hour minus lunch breaks, etc.  I just don't want to pay for a course if it does not have this type of detail explanation in it.  Sorry if I am asking the same thing, just not getting a satisfactory resolution.  
Thank you.
Alex Hedley 
There's also another Timesheets (Calculating Total Hours for Employees, Billing, etc.) TechHelp
Alex Hedley 
- nearest quarter hour
Above video

- removing breaks
Calculate Total Time w DateDiff
Richard Rost 
Calculating to the nearest 15 minutes is covered in this video. I don't understand what you are trying to do differently. As far as removing breaks goes, that's going to involve some significant programming, much like removing holidays and non-work days does. I cover that in Calculate Total Time w DateDiff video that Alex posted. Everything you're asking for has already been covered in different videos. You just need to put it all together for your own custom needs. It's like I always say: building with Access is like playing with Legos. You can put the pieces together any way you want. If you want an easier solution, split up your entries into two times: one before lunch, and one after. Have them clock IN and OUT and then you can easily add that together instead of trying to pull times OUT of the middle.
Richard Rost 
If you want to take a bunch of existing calculations and round them to the nearest 15 minutes, then you'll have to use the above technique and run your times through an Update Query.
Lydia ONeal 
Please provide me with the link to the 40 minute extended video referenced in your 'Time Spent' free tech video.  It goes through setting up exclusions.  I believe I should be able to get this since I signed up for gold membership, correct?  I went directly to YouTube and I am not seeing the link you reference in the video.  Thank you.
Richard Rost 
It's right here: Time Spent. Yes, you have access to it as a Gold Member, but since you signed up here on my site, you have to watch it on my site. You cannot watch it on YouTube. This is all explained in the signup info.
Lydia ONeal 
Thank you Richard.  Got it.
Lydia ONeal 
I have learned lots on the extended cut video.  Thank you.  I am having a problem with the Option Explicit on my DB.  It returns a 'Compile Error' on the Exclude Weekends as such.  
       CurrentWeekday = Weekday(CurrentTime)
       If excludeweekends And (CurrentWeekday = 1 Or CurrentWeekday = 7) Then
            ' it's a weekend, skip.  
       Else
The compile error goes away when I remove the Option Explicit.   What would I need to do in the Tools Reference list and/or in the code to fix this?
Richard Rost 
Option Explicit means you have to explicitly declare your variables or they need to be fields on an underlying form. Generally you get this error message if you have something spelled wrong or you forgot to DIM a variable.
Lydia ONeal 
I found the problem.  Thank you.
Richard Rost 
Well, now you have to share with the class. What was it? :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in 15-Minute Increments.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 6:39:36 AM. PLT: 1s