# How can I calculate time with a large pool of raw data?

Occasional Visitor

# How can I calculate time with a large pool of raw data?

Good Evening,

I'm self taught when it comes to formulas in Excel so if this is a very simple answer I apologize, as I had to learn (and quickly)  because my boss doesn't know how to use Excel at all.

Situation: My company sends reports out which will have literally thousand of account numbers say in cell A. In cell B, they have time stamps indicating what time an employee accesses that account to do whatever internal coding is listed in cell C, on the date listed in cell D. (there is a Cell that had each employees operator ID in Cell E)

*Each employee has their own Excel tab but there is also a tab with everyone just mixed it*

My Issue: When I look at these reports Cell A can repeat multiple times depending on how much was done by one employee (indicated in cell C) on a particular date (Cell D).

Ex: This is how one persons first 8 entries can look on this huge report

 A B C D This row added in just for clarity and doesn't exist on the report (account number) (Time) (Process) (Date) 1 123 7:00:00 AM Accessed Billing 1/2/2021 2 456 6:59:13 AM Contract Issued 4/6/2021 3 123 7:03:02 AM Prepared Mailing 1/2/2021 4 123 7:05:00 AM Financial Review 1/2/2021 5 123 7:13:24 AM Sent out Mailing 1/2/2021 6 456 3:01:00 PM Correspondence 3/1/2021 7 789 12:00:00 PM Outbound Call 3/1/2021 8 123 12:05:12 PM Financial Review Edit 3/5/2021

What I need to do: I need to figure out how long each employee spent in each account each day.

What I have been doing (Unsuccessfully): I have been sorting by oldest date and then by time smallest to largest, and then trying to figure out a formula that I could enter in to Cell F that would tell me how long that employee spent in each account each day.

These reports literally have thousands of entries since they run it each quarter and want to monitor everyone's time in each account for the employees KPI (key performance indicators) as well as security concerns.

My work around has been asking the data person to run and send me everyone's report each day, then I manually figuring it out because I know I wont have the time to do it for all 40 employees.

I also started to try and learn about IF AN NOT formulas on my lunch break this evening and I tried something like =IF(A2,(AND(D2)),SUM(B2:B9)), which gave me a result of "True", which I think I know why it did, but again, I'm learning on my own on my breaks and lunches.

Request: Is there a formula I could use that when populated could calculate how long each employee spent in each account each day?

Additional Information: We use Windows and I think we have Excel 2013