Rotate Hand to face object
Hello.
I'm trying to rotate a hand bone so that the palm faces an object. I have found a lot of examples showing how to rotate a 3d object around one axis (up) but these seem to assume that you are working straight up and down.
I'm looking to rotate a bone, that is already tilted in a direction (due to animation) so that the palm of the hand faces an object. So rotating on a single axis (in the case of the hands X is up or X is down depending on which hand) but keeping the existing rotations.
You can see in the image below that the red line (the hand) already has rotations applied to it, but now I need to rotate it along the long axis so that it faces the red object.
Any suggestions would be appreciated. Everything I've tried seems to flip the hand to be straight up and down, then spun towards the object, it doesn't respect the existing rotation.