1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Hi Guest, welcome to the TES Community!

    Connect with like-minded professionals and have your say on the issues that matter to you.

    Don't forget to look at the how to guide.

    Dismiss Notice
  3. The Teacher Q&A will be closing soon.

    If you have any information that you would like to keep or refer to in the future please can you copy and paste the information to a format suitable for you to save or take screen shots of the questions and responses you are interested in.

    Don’t forget you can still use the rest of the forums on theTes Community to post questions and get the advice, help and support you require from your peers for all your teaching needs.

    Dismiss Notice

Calculating time in MS Access

Discussion in 'Computing and ICT' started by dekka, Jan 24, 2012.

  1. You won't need to use the Datediff function for this.

    If you follow this link halfway down there is a zip file to download for an Access Form which provides a solution for you (takes less time than me faffing about explaining it.

    http://forums.techguy.org/business-applications/518025-ms-access-time-calculations.html
     
  2. it1

    it1 New commenter

    Thanks everyone. I solved it myself eventually...wished I did A-Level database projects more than once a yr and then I might remember this stuff.
    Length - data type as date/time but then formatted using h:nn to represent hours and minutes

    Then simply added the 2 fields together in a query and that solves it.
     

Share This Page