Formula Advice on how to Average a column

[VBA learner ITG]

Hi Peers,

I have tried google and cannot find a solution to be able to average a column based on the below.

This is the formula in the cell which is how the below value in the column/cell is presented: =IFERROR(NETWORKDAYS.INTL(C3,D3)-1&" days "&TEXT(D3-C3,"h"" hrs ""m"" mins """),"")

Any advice appreciated?

1 days 4 hrs 26 mins

2 days 5 hrs 20 mins

0 days 0 hrs 0 mins

4 days 6 hrs 53 mins

3 days 21 hrs 26 mins

2 days 18 hrs 37 mins

2 days 18 hrs 39 mins

 

[jasonb75]

You can't perform mathematical operations on cells which contain text, you will need the numeric equivalents of the results in order to perform any additional calculations.

=NETWORKDAYS.INTL(C3,D3)-1+(D3-C3)