How do you average text formulas??

I have this formula which calucates time differences =TEXT(F70-B70,"d:h:mm")
format= 1:12:45

Everytime I use the "average(h7.h20)" the answer equals "#Div/0"
I'm trying to average all these formulas, how do I average these cells that
contain the =TEXT(F70-B70,"d:h:mm") format

Hi!

Why use the TEXT function?

Why not just:

=F70-B70

And custom format as d:h:mm.

Biff

>-----Original Message-----
>I have this formula which calucates time differences =TEXT
(F70-B70,"d:h:mm")
>format= 1:12:45
>
>Everytime I use the "average(h7.h20)" the answer
equals "#Div/0"
>I'm trying to average all these formulas, how do I
average these cells that
>contain the =TEXT(F70-B70,"d:h:mm") format
>.
>

How about just putting
=F70-B70

in the cell and give it a custom format of:
d:h:mm

(really d:h:mm???? That looks unusual to me.)



bladelock wrote:
>
> I have this formula which calucates time differences =TEXT(F70-B70,"d:h:mm")
> format= 1:12:45
>
> Everytime I use the "average(h7.h20)" the answer equals "#Div/0"
> I'm trying to average all these formulas, how do I average these cells that
> contain the =TEXT(F70-B70,"d:h:mm") format

--

Dave Peterson