Gustav Brock
gustav at cactus.dk
Mon Jul 12 09:41:45 CDT 2004
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