I think the reason you get #div/0 is that the field is a text field
On what cells and formulas do you do your average calulation.


"Steve COR" wrote:

I have a spread sheet that counts how many days and hours have past from a
set date and time entered into another field. I would like to show averages
but for some reason I get #DIV/0!. Here is the formula that counts the days
and hours: =INT(NOW()-K18)&" Days, "&ROUND((NOW()-K18-INT(NOW()-K18))*24,0)&"
Hours"
I need to find the average days and hours
thank you for anyhelp in advance, Steve