paul.hartland at fsmail.net
paul.hartland at fsmail.net
Mon Jul 12 09:24:03 CDT 2004
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 -- 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