add up HH:MM:SS (Office 2007)

[ArviLaanemets]

In attached, filtered calls are counted and totaled.


For duration, a format is used which allows durations > 24 hours displayed.


Subtotal function used in top of page calculates counts/sums displayed in Table tCallData for displayed records, whatever autofilter conditions are applied to Table tCallData.


You copy data from bill into Table tCallData (Use PasteSpecial > Values to avoid overwriting formats on sheet CallData), and add CallType values for every entry. I think the workbook will cope with calls of full year easily.