# Thread: Running Time Multiple Users, Access 2010

1. Registered User
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.

2. Registered User
Join Date
Apr 2014
Location
Kentucky
Posts
629
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.

Join Date
Feb 2004
Location
New Zealand
Posts
1,482
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.

4. Registered User
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.

Join Date
Feb 2004
Location
New Zealand
Posts
1,482
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
JDate
..
..
..

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.

#### Posting Permissions

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