Formula or Function for call log tracking

Hi, I was wondering if anyone would possibly help me with finding a easy and fast way to track call logs. I am looking for a way to track the total number of in house calls, outgoing calls to customers, Average call duration and total call time. I have attached a sample of what the call logs look like. Excel is kind of new to me so any help would be great.

First thing: Convert the data into an Excel table. There are a lot of benefits tables provide. The three used here are: the table grows and shrinks to accommodate the exact amount of data you have. Tables copy down formulas automatically. Formulas referencing the tables are easier to read. You can get more information on tables here: http://www.utteraccess.com/wiki/inde...ables_in_Excel.

I had to add a helper column: N Duration. This is because the durations in the table are actually strings that look like times instead of actual times and they have to be converted. The formula in this column is:

Please Login or Register  to view this content.

I gave you two fields: M1 and M2 that I named Start_Time and End_Time.

The rest is formulas in cells M5:O10.

Please Login or Register  to view this content.