said by KrK:Any chance you could plant a tree that would grow to a large shade tree? This is slow process and may not be feasible, but it helps. Also don't plant it too close to the house.
Other then that, you could try adding insulation to that upstairs room.... and by all means, tinted windows and window shades DO help some.
Good luck!
Also, something I do to save electricity: This fan powerful, moves a lot of air... (but somewhat noisy). Really helps though, makes me feel better and saves turning down the A/C.
Thanks for the suggestions....I have a fan in the door now....haven't quite figured out if blowing in or exhausting out is more beneficial.
You can tell the temp diff as soon as you step into the hall, which is why I was wondering about putting a return in the office, to see if it would move some of that air.