Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » All Tags » Worksheet Functions » VBA (RSS)

Browse by Tags

  • Clock Face Angles

    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...
    Filed under: ,

  • VBA Rounding

    When comparing values from various systems, I’d sometimes notice $0.01 differences. I put the differences down to rounding, but it seemed that no matter which approach I took, the differences could not be reconciled. It’s one of those things that really bugged me, and I’d feel guilty if I spent too much time on the problem… after [...] Read More...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.