[AccessD] Summing Time

So you just Group By INPUTDATE and Sum the Time and you should be fine.

-Chris Mackin

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
paul.hartland at fsmail.net
Sent: Monday, July 12, 2004 8:53 AM
To: Access Developers discussion and problem solving
Subject: Re: Re: [AccessD] Summing Time


Not sure I explained properly an example table would be:
INPUTDATE                  TIME
28/06/04                        00:10
28/06/04                        00:10
28/06/04                        00:12
28/06/04                        00:10
28/06/04                        00:13
28/06/04                        00:10
28/06/04                        01:18
29/06/04                        00:10
29/06/04                        00:10
29/06/04                        00:30
29/06/04                        00:10
29/06/04                        00:13
29/06/04                        00:10
29/06/04                        02:00
 
So if I entered 28/06/04 as the start date and 29/06/04 as the finish date I would get
 
TotalHours
04:48
 
I only want to sum the actual time field
Paul Hartland





Message date : Jul 12 2004, 03:44 PM
>From : "Gustav Brock" 
To : "Access Developers discussion and problem solving" 
Copy to : 
Subject : Re: [AccessD] Summing Time
Hi Paul

lngWaitMinutes = DateDiff("n", datefield1, datefield2)

/gustav


> To all,
> I have a database which holds the shifts of inputting based on various orders that are being counted, one particular field of the record is waiting time, which will hold anything from 00:01
> upwards. I also have a date field in the record called InputDate, what I want to be able to do is allow the user to enter two dates then calculate the total waiting time there was between the two
> dates, thought I had done this but apprently it's not calculating correctly. 
> Any ideas how I can calculate this exactly to the minute.
> Thanks in advance for any help.
> Paul Hartland

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com