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
>.
>
Bookmarks