473,503 Members | 3,866 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Calculation of Time Cards of two shifts

42 New Member
I created a form with “Time In1”, “Time Out1”, “Time In2”, “Time Out2”. I’m able to calculate the time correctly when it was during the day shifts from 7:00 AM (Time In1) 5:00 PM (Time Out1) = 10:00 but when the time goes over 12:00 AM it appears that it was totaled twice. Ex: 4:00 PM (Time In1), 12:00 AM (Time Out2)= 16:00
Here’s the calculation I used:
=NZ([Time Out1]-[Time In1])+NZ([Time Out2]-[Time In2])
Please help.
Thank you
Oct 14 '08 #1
2 1455
DonRayner
489 Recognized Expert Contributor
Try using the datediff function instead
Oct 14 '08 #2
John Torres
42 New Member
Thank you. That works!!!
Oct 16 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
852
by: nntp.microsoft.com | last post by:
Anyone aware of any ready made C# classes/modules for processing credit cards for Authorize.net and shipping method calculation for UPS?
2
2265
by: N3TB1N | last post by:
Let me try again. I could use some help with this assignment, even though my teacher does not grade assignments.but because I need to know this stuff for a test very soon, but haven't been in...
13
4356
by: Steve Jorgensen | last post by:
Does this sound familliar to anyone? Regardless of the fact that you have been programming in Access for umpteen years, you still are overly optimistic when it comes to estimating time. The...
4
3258
by: Michiel Alsters | last post by:
Hello everybody, I hope anybody can help me. I'll try to give a brief overview of my problem. I have running a program that performs a heavy calculation. To give the user feedback what the...
0
2996
by: Limpor | last post by:
Hello, I am new to learning java, and i am trying to build the class for a calculation card game, unfortunately i can't get the public Card top() and Card takeTop() method in the Stock class. Can...
2
5343
by: pcbutts1 | last post by:
This is a simple mortgage calculator and it compiles but I am totally confused on the calculation to get it to work. Can someone help me a little. import java.util.*; import javax.swing.*;...
0
1620
by: RSH | last post by:
Hi, I have a situation where I am using a dataset from a SQL Query. SQL's DateTime is a "long date/time field" which includes the Date/Time. My fields need to be displayed in a short time...
13
1968
by: Maria Mela | last post by:
Hello everyone... Anybody can help me on this question, please? i´ve this code in my application: /*for Card creation*/ typedef struct card { etc,etc } Card; typedef Card *PtrCrt;
2
1005
by: Greg (codepug | last post by:
A company has 4-shifts (ie 1,2,3,4) and each shift is 1-day (24hrs), and the shifts repeat after they complete. Shift 1 to 4 is Monday to Thursday, so the following Shift 1 to 4 is Friday to...
0
7207
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7291
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7012
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7468
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5023
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4690
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
1522
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
748
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
402
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.