#Value error when using correct formula in Excel 2007

October 14, 2012 at 01:33:58
Specs: Windows XP, dual core/ 2 GB
=09/30/2012 23:45+"9:30" then its giving #Value!
=10/08/2012 04:01+"9:30" then its giving 10/08/2012 13:31
in excel 2007
Same when i used on my colleagues PC same sys and excel config its giving correct result.
mail me on email address removed

edited by moderator: email address removed


See More: #Value error when using correct formula in Excel 2007

Report •


#1
October 14, 2012 at 05:18:46
Please do not post your email address in this forum.

We do not want to become known as a site where email addresses can be harvested. Once the bad guys start hanging we could be subject to all sorts of security issues.

I have removed the email address from your post.

DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
October 14, 2012 at 07:54:59
Are you really putting the an Equal Sign followed by a Date followed by a Time etc.
into a cell, like your example?

=09/30/2012 23:45+"9:30"

MIKE

http://www.skeptic.com/


Report •

#3
October 14, 2012 at 08:16:09
I tried pasting those formulas into 2010 and Excel sure didn't like them.

For =09/30/2012 23:45+"9:30" Excel suggested =9/30/45:201223+"9:30" and returned a #VALUE error.

For =10/08/2012 04:01+"9:30" Excel suggested =10/8/1:201204+"9:30" and told me that I had a Circular Reference which (as expected) returned 0 when I clicked OK.

If I do this, everything works fine:

          A                  B
1   10/08/12 4:01	=A1+"9:30"
2   09/30/12 23:45	=A2+"9:30"

Producing:

          A                  B
1   10/08/12 4:01	10/08/12 13:31
2   09/30/12 23:45	10/01/12 9:15

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
October 20, 2012 at 00:52:10
I think you made any mistake while giving the values.Make sure your input values.You can learn date and time functions with video tutorial from http://www.hscripts.com/tutorials/e...

Report •

Ask Question