Hello,
Need some rudamentry help adding together durations in 00:00:00 format. Need cell K8 to calculate the duration total in column D. Will be using attached sheet as a master database for data collection efforts to track call durations and totals. Will be adding records daily going forward.
Would like the formulas to auto calculate as records are added. The current way is not feasible (=D2+D3+D4+D5+D6+D7+D8+D9+D10+D11+D12+D13+D14+D15+D16+D17+D18+D19) and would have to add each cell in manually. Also auto SUM doesnt seem to work in this scenario. Any advice would be greatly appreciated.
Thanks
Bookmarks