I have created a table from a text file. I need to create some queries to perform calculations and I am not sure how to go about it. In the table is the name of the employee, date and the transactions they completed. I brought over the transactions field as text but it represents the transactions performed as time. For example; the first transaction for that day was 8:45am, followed by 8:47am and another at 8:59am. I need to first find out how many hours the employee worked and how many transactions per 1/4 hour the employee performed from this field. In this example, it was three transactions between 8:45am and 9:00am (three per quarter hour) If this holds and the employee works 8 hours minus a lunch, it would be about 84 transactions for that day. I don't work with calculations a lot and I need a way to do this. I hope I provided enough information to grasp the concept I am trying to do.
You are not providing enough information on how you want the final result displayed. Do you want an average transaction rate per quarter hour? Or do you want a listing of each quarter hour and how many transactions occured in that quarter hour.