Thanks for that.
In your opinion would all the formulas work in practice? I have tried 1 out but was a case of nearly bit not quiet there. A result of 3:39 should of been 2 something.
After trying a few more, most work ok.
I'm just after formula confirmation but with atan2() instead?
I believe I have worked out the answer.
In excell if two distances are stored in cells J16 and J11
then if direction is NW then use (ATAN(J16/J11)*180/PI())
If direction is SE then use 180-(ATAN(J16/J11)*180/PI())
If direction is SW then use 270-(ATAN(J16/J11)*180/PI())
If direction is NW...
Thank you for your reply.
Good point.
I was thinking that north will always be 12 o'clock = 0 deg for this I would need an if statement for excel (assuming deg is in cell A1) e.g =IF(A1/30=0,12,A1/30)
east will always be 3 o'clock = 90 deg = 90/30 = 3 o'clock
south will always be six...
This is not a a school or college question, it is just for my interest.
Homework Statement
suppose I travel 605 meters North , then travel 673 meters West.
I have calculated shortest distance of Sq Root(605^2 + 673^2) = 905 meters
What I am now trying to calculate is direction to face...