Recent content by medelec35

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...