Search results

Gemma That seems to work ok if I use dd mm yy ie 14/10/06 - 13/10/06 = 1, but if I then put hh mm ss in I get 14:03:40 - 14:03:27 = 0.000150462962962949 What is this all about ??

Hi Newbie to Access so bare with me. I am making a database to log working hours onto for different contracts I work on. The fields I am having a problem with are "start date and time", "End date and time" and then "Elapsed time" I need to populate these fields in the format 13/08/2006 17:20...