how to add date and time to a single cell in MS Excel 2007
If you are getting a #VALUE! error, it's because at least one of your
arguments is text, not a number. I guess that your 01.03.2009 is text, so
you need to convert it into an Excel date.
--
David Biddulph
"Anil123" wrote in message
...
Hi,
Iam trying to add date column ( 01.03.2009) and time column (23:30:00) to
a
single cell to get the result as 2/28/2009 23:30 using the formula :
=IF(A1<"",A1+B1,""), But its throwing an exception of #VALUE!
Please help in this regard.
Thanks,
Anil
|