Solved

Difference between two times

Posted on 2013-11-29
2
393 Views
Last Modified: 2013-11-29
Hi,

I am using DateDiff in Access 2010 to show the time difference between 2 times.

Minutes: DateDiff("n",[ClockInTime],[ClockOutTime])

The above works fine, unless ClockOut time is after midnight, in which case I get a negative and inaccurate result.

Can anyone tell me how I need to modify this simple query so that when I run it I get the correct results.

Thanks
0
Comment
Question by:LJShepherd
2 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39685199
Hi,

pls try (supposing it cannot be more than 24 hours)

Minutes: DateDiff("n",[ClockInTime],IIf([ClockOutTime]<[ClockInTime],[ClockOutTime]+1,[ClockOutTime]))

Open in new window


Regards
0
 

Author Closing Comment

by:LJShepherd
ID: 39685213
Brilliant, works perfectly thank you!
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access 2016 5 53
deduplicating based on criteria 2 21
Turn off MS Access Default=0 for Numerics 6 25
Binding recordsets to a form 6 23
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question