Results 1 to 3 of 3
  1. #1
    Doria is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2015
    Posts
    2

    Calculate times inbetween two startup times.

    Hi folks,

    Im trying to make query to tell me how many hours and minutes it is between two startuptimes.

    I have a machine that starts and stops which is recorded on a table. Each cycle counts as autonumber.
    I have a startup time and a stop time recorded as HH:MM.

    Anyone knows how to calculate the time it goes between startuptime @ cycle 1 and startuptime @ cycle 2 ?


    These cycles occour on diffrent dates. Hope there is a way to get this to work

    EDIT:
    Basically what i want to know is much time it goes between each Startup of the machine.


    Thanks,

    ps, sorry for my bad english.

    Best regards,
    Doria

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Doria is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2015
    Posts
    2
    Thanks, will do that

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 11-08-2014, 07:28 PM
  2. Calculate Minutes Between Two Dates and Times
    By robrich22 in forum Programming
    Replies: 3
    Last Post: 01-31-2014, 07:56 PM
  3. Replies: 5
    Last Post: 09-11-2013, 03:42 PM
  4. Different between two times......
    By matthewjones108 in forum Access
    Replies: 2
    Last Post: 04-27-2012, 03:58 AM
  5. Filter between times
    By bigderon88 in forum Queries
    Replies: 1
    Last Post: 03-30-2012, 02:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums