[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