I am familiar with the Help feature. here is a formula that did work.
=INT(NOW()-K11)&" Days, "&ROUND((NOW()-K11-INT(NOW()-K11))*24,0)&" Hours"

It counted 4 Days, 4 Hours

Now useing the same exact foormula nad moving it to a different set of
fields to count another date and time, it returns a value of "#VALUE"

Why would it have worked in the past and not now when I want to enter new
data or use the same formula in a different set of fields? Something
happened, and no Help can Help. That is why I am asking in this forum.
Occasionally anomolous activity happens and there is no good way to phase
your question in a Help feature, so I have come here. Do I need to "Unload"
my Add-ins and re-add them?

I am at a loss...


"David Biddulph" wrote:

I find it very hard to believe that the formula expressed the way you have
it has worked in the past.
Excel has a feature called "help"; why not type the name of the function
NETWORKDAYS into help (or click on fx alongside the formula bar) and see
what the syntax ought to be?
--
David Biddulph

"Steve COR" wrote in message
...
I have had this formula forever. "=NETWORKDAYS(B1-B2)" It counts just the
workdays in-between two dates. It has worked fine, but all of a sudden now
it
will not work. I checked the Add-Ins and they are still there. Has anyone
ran
across this problem before?

Thank you in advance Steve