Financial RAD Developer quotes this interview question
Please tell me what you would implement to tell me the angle between then hands on a watch face at any given time of the day.
Here’s my worksheet function to convert time to angle
=ABS(((MOD(HOUR(G2),12)/HoursPerDay*DegreesInCircle)+((DegreesInCircle/HoursPerDay)*MINUTE(G2)/MinutesPerHour))-DegreesInCircle/MinutesPerHour*MINUTE(G2))
And my VBA
Function TimeAngle(dtInput As Date) As Double
Dim dHour As Double
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2011/04/21/clock-face-angles/
Posted
Apr 21 2011, 07:30 AM
by
Daily Dose of Excel