Free Lessons
Fast Tips
Topic Index
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Directory > Access > 15-Min Increments < Outer Joins | AutoTab >
15-Minute Increments
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   2 years ago

Back to 15-Minute Increments

Time Calculations In Query Upload Images   Link  
Lydia ONeal 
14 months ago
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
14 months ago
Did you watch the Extended Cut?
Lydia ONeal
14 months ago
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
14 months ago
There's also another Timesheets (Calculating Total Hours for Employees, Billing, etc.) TechHelp
Alex Hedley
14 months ago
- nearest quarter hour
Above video

- removing breaks
Calculate Total Time w DateDiff
Richard Rost
14 months ago
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
14 months ago
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
14 months ago
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
14 months ago
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
14 months ago
Thank you Richard.  Got it.
Lydia ONeal
14 months ago
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.  
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
14 months ago
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
14 months ago
I found the problem.  Thank you.
Richard Rost
14 months ago
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, below.

Back to 15-Minute Increments Comments

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

5/31/2022List Items Set Value
5/28/2022Access Bug Alert #Deleted
5/27/2022Add Anything
5/26/2022List Items Edit Form
5/25/2022Column Colors
5/24/2022Multi-Table Forms
5/21/2022Access Developer 39
5/21/2022Access Developer 39 Lessons
5/21/2022Access Developer 39

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn