I have a tracking tool that has worked well in 2003, but when I convert the file to 2007 (and I get the message that it converted successfully), I am getting an #NAME? error in a column. The formula in that column is:
=WorkingHrs(D80,G80,0,1,"2
3456",3932
8,39363,39
440,39441,
39442,3944
3,39444,39
448,39528,
39531,3958
6)/24
and it appears the term "WorkingHrs" is giving me the problem. Any thoughts?
Thanks,
Andrea
Start Free Trial