It worked for me, but can be simplified to

=INT(NOW()-K18)&" Days, "&ROUND(MOD(NOW()-K18,1)*24,0)&" Hours"

What is in K18?


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Steve COR" wrote in message
...
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