Gustav Brock
gustav at cactus.dk
Mon Jul 12 10:12:32 CDT 2004
Hi Paul
> 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
Then you can get the minutes for each record:
WaitMinutes: DateDiff("n", #00:00#, datefield2)
and sum these.
/gustav
> 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