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

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