Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2017
    Posts
    2

    Unanswered: Running Time Multiple Users, Access 2010

    I am creating a database to track cases that the company handles. The cases can have multiple people work on them. When they are being worked on I need the start time, stop time, pull call start time, pull call stop time, out bound call start time, out bound call stop time, pause start time, pause stop time where the first 3 start and stop times are added together and then the total pause time is subtracted so that I get the total time that has been worked on the case.

    This is a database for a call center. The cases are items that have to have special approval on. The people that work on the cases are senior agents who take calls from junior agents that have an issue that they are having trouble solving. So when a senior agent is working on a case and a call comes in they have to pause working on the case to help the agent on the phone, and then star working on the case again and may have to pause several times so the time that the senior agent isn't work on the case has to be subtracted from the total time in order to get the actual time worked on the case.

    Needing help in setting it up so that it will work correctly.
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    629
    Provided Answers: 33
    a table w fields:
    USER, EVENT, STARTTIME, ENDTIME
    user,get call, 2/27/2017 5:42 AM , 2/27/2017 5:52 AM
    user,pull, 2/27/2017 5:51 AM , 2/27/2017 5:58 AM
    user,get coffee, 2/27/2017 6 AM , 2/27/2017 6:08 AM


    then you can sum any event for any dept.

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,482
    Provided Answers: 11
    Been there done it

    I Put every thing into Minutes

    MINS = datediff('n',[Starttime],[Endtime]) think its the right way round

    why cause the maths is easier

    60min+30min=90min

    wrote this function to Display the total mins in a time format
    hh:mm which get displayed on the reports

    Code:
    Function Mintohrs(Tmin)
        hh = Int(Tmin / 60)
        tt = hh * 60
        MM = Tmin - tt
        Mintohrs = Format(hh, "##00") & ":" & Format(MM, "00")
    End Function

    hours:mins = MintoHrs(90)

    hours:mins = 01:30
    Last edited by myle; 02-27-17 at 14:51.
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  4. #4
    Join Date
    Feb 2017
    Posts
    2
    Myle

    Can you help me setup the tables and other stuff. I am fairly new to access and could all the help possible. Thanks in advance.

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,482
    Provided Answers: 11
    Yeap can do

    Fire you Question Here

    1st lession

    Get heaps A4 bits of paper write the info you want to keep

    something like

    First Name
    Surname
    DOB
    UserName
    Adate
    JDate
    ..
    ..
    ..

    I would Name this page USERS Well that come the TABLENAME
    MY rule is Have a PK same name as the Table
    USERSID is a PK autonumber (i dont use it for anything BUT link to other tables)


    Next A4 bit of paper (next Table)

    Job <=this could be and other table I think
    USERSID we can see what table it come from with reading anything else
    Starttime
    Endtime
    do we need to store mins??


    Keep Fulling up the A4 pages

    if you start storing same data on differance bits of paper then they need to be on there on page
    and just put the PK of that table on it Now its the FK

    Then What i do is think Look at the BITS paper for about a week looking ways to store the data once

    What data can i get out of it does it match the bref

    do i need to add MORE FEILDS to my pages
    its make it hard to add a feild and you have a 100,000 records that need updating
    for me the THINKING PART is one of the most inprotant
    Last edited by myle; 02-27-17 at 21:14.
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •