I am trying to create a time sheet. I am having problems Subtracting the TimeOut from the TimeIn. This is what I get when I subtract two Short Time&#039s from an ACCESS database "8.40277777777777E-02" The times are in the correct format except there is an AM or PM extension that ACCESS puts in. What is the best way to declare fields in the database and storing them to be able to calculate the total time spent?