I need to summarize phone calls in Excel to prove how many hours, mins and seconds I spent on the phone for something. I'm a very basic Excel user, so please spell it out for me. Code: DAT DURATION ...
Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with confidence.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback