### 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