Excel Forum

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

Got a Question? Ask it Here in the Forum.