This is a multi-part message in MIME format.

------_=_NextPart_001_01C20737.84B926EA
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks Marco

TO: Jack and Cardyin, and whoever can benefit from this

Here is how I decided to approach this issue...

I have the following fields in my table

InOut, Time, User, Description

I decided to get rid of Description and make InOut an Integer.

1 =3D In for the day
2 =3D Out for lunch
3 =3D In from lunch
4 =3D Out for the day
(Since we don't document breaks this is all I need)

This makes adding easy all I have to do is select the the 2 integers
that I want to add up, AND I've eliminated a field!

Thought I would pass it along

Thanks for all your help

Joe Conaty
Nations Direct IS Dept
(xxx) xxx-xxxx  Ext 221

-----Original Message-----
From: Straforini, Marco [mailto:marco.straforini@c...]
Sent: Wednesday, May 29, 2002 10:23 AM
To: professional vb
Subject: [pro_vb] Re: Adding/Totaling time


If you mean you need to get the time difference in hours:minutes, then
use DateDiff("n", timein, timeout) to get the difference in minutes. The
hours are the integer division by 60, and the minutes are the reminder.

Marco

-----Original Message-----
From: Joe Conaty [mailto:joec@s...]
Sent: Wednesday, May 29, 2002 8:53 AM
To: professional vb
Subject: [pro_vb] Re: Adding/Totaling time


Thanks Jack,

This part works fine.  I need to separate them though.  (I wish I would
have used separate fields for in and out)

any suggestions.  I have a few theories, but I don't want to get caught
up traveling down the wrong road(I have a tendency to do that)

Thank in advance


--- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to