|
Featured Tutorial
Featured Macro
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
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