Main Profile

At A Glance

Excel Magic Trick 682: Averaging Times Entered As Text (3 Examples) Array Formula

See three methods to averaged times values that were exported from a database as text values instead of number values: 1) AVERAGE and IF array formula 2) Text to Columns feature 3) AVERAGE, IF and TRIM function array formula Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm
Length: 06:22

Contact

Questions about Excel Magic Trick 682: Averaging Times Entered As Text (3 Examples) Array Formula

Want more info about Excel Magic Trick 682: Averaging Times Entered As Text (3 Examples) Array Formula? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question