Inputs are Date and time : "2/25/2008 8:58:00 AM" in one field the field
next to it has the following formula: "=INT(NOW()-K11)&" Days,
"&ROUND((NOW()-K11-INT(NOW()-K11))*24,0)&" Hours""

It returns the value: "4 Days, 5 Hours"

Now as you can see by the date I entered that date and time on 25 feb 08
8:58:00 AM, since then actually last two days I have tried to make similair
logs in the sheet the next row down I copy-paste the formula and type in the
date and time I want, and get "#VALUE!"

That is the whole issue....nothing has happened to my computer in the last
two days. All I can think of is some system update wiped out something. I did
have to add some add-ins to get it to count these days. That is why I think
it is a add-in thing. But how do you unload and reload add-ins?



"Niek Otten" wrote:

<back to main point

The main point is:

What exactly is your formula, what are the values of the input cells, what result did you expect and what did you get instead?

<why was it working and now not

If you change anything (location, input cells, values of the input cells, properties of the input cells like they being text or
numbers (the difference is invisible), short: *anything at all*, the results of your formula may change.

Please be very specific. You're dealing with computer software, not with an understanding wife or neighbor :-)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Steve COR" wrote in message ...
| Well guess I should have used the Networkdays formula and stuck with it. But
| it is doing the same thing anyway. When I mean by moving the formula to
| different fiels I mean the copy/paste the formulas, you know, how you can get
| the formula right once then just propogate it through the rest of the
| spreadsheet.
|
| But, back to main point why was it working and now not?
|
| "Niek Otten" wrote:
|
| I don't see what this formula has to do with your original question about NETWORKDAYS().
|
| What do you mean with "moving it to a different set of fields"? Dragging the formula to a different location? Copy and paste?
| What are the values of the new input cells (cell references have changed in the move/copy process)?
|
| Please be more specific
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|
| "Steve COR" wrote in message ...
| |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
| |
| |
| |
|
|
|