Excel link

[rroy676]

Hi,

I am trying to inter link an excel spreadsheet with project and would
like to an IF function to add revised dates from project based on the
actual dates entered into the excel spreadsheet. When I try to use the
comparison operator not equal to (<>), it never gives me the correct
result beacuse the link from project to excel includes the time (IE
there is an extra decimal value in the excel spreadsheet compared to
the value entered in excel). Is there any way to remove the time from
the project link?

Thank you,

Robert Roy

 

[JackD]

You can't remove the time from the link as it just points to project and
project needs the time. But you can round the value in your formula by using
round(whatever, 0) or integer division
http://zo-d.com/blog/archives/programming/vba-integer-division-and-mod.html

so instead of:

if(projectfoo<>excelfoo,"no match", "match")

you would use:

if(round(projectfoo,0)<>excelfoo,"no match", "match")

 

[John]

Hi,

I am trying to inter link an excel spreadsheet with project and would
like to an IF function to add revised dates from project based on the
actual dates entered into the excel spreadsheet. When I try to use the
comparison operator not equal to (<>), it never gives me the correct
result beacuse the link from project to excel includes the time (IE
there is an extra decimal value in the excel spreadsheet compared to
the value entered in excel). Is there any way to remove the time from
the project link?

Thank you,

Robert Roy

Robert,
Well, no and yes. I've never tried to use a conditional in conjunction
with a link so I'm not real clear on how you are doing it but the bottom
line is that time is always a part of any date - and it has to be - even
in Excel. The difference you are experiencing is probably in the fact
that Project dates are normally expressed as working time wherein a
"day" starts at 8:00 am and ends at 5:00 pm. In Excel days start at
12:00 midnight and run until 11:59 pm (i.e. 24 hour day).

Depending on how the conditional is structured the time part of the date
could be truncated (e.g. use the "Mid" function) or adjusted for
compatibility (i.e. translate 8:00 to 12:00).

Hope this helps.
John
Project MVP