Excel Forum
Similar Content
Format Cells as Text in Excel
Macro: This free Excel macro formats a selection of cells as Text in Excel. This macro applies th...
Find the Most Frequently Occurring Value in a List in Excel
Tutorial: Use a formula to return the most frequently occurring word or value from a range of cells...
Prevent Spaces from Being Entered in Text in Excel
Tutorial: How to prevent a user from entering any spaces within text in Excel.  This allows you to ...

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.