How do you average text formulas??

G

Guest

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
 
B

Biff

Hi!

Why use the TEXT function?

Why not just:

=F70-B70

And custom format as d:h:mm.

Biff
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation not correct 1
#DIV/0 error 2
How to combine, IF, AND, OR Functions 2
Average 1
Average If Statement (Excel 2003) 11
average if (different cells) with formulas 5
How do I average a group of cells and ignore a #div/0! error? 8
Average Formula 1

Top