+ Reply to Thread
Results 1 to 2 of 2

Help function to calculate clock bearing in VBE!

  1. #1
    Registered User
    Join Date
    09-19-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Help function to calculate clock bearing in VBE!

    Help I need to write a function that calculates a clock bearing (1-12) from bearing angles (0-360) degrees. Where 12 o'clock is straight ahead and bearing on the border (eg 45 degrees) can return either adjacent value.
    Function is bearing(ByVal bearing As Double) As Integer

    Conceptually I know what to do but starting to write the function I'm clueless :-(

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Help function to calculate clock bearing in VBE!

    Start with:


    Please Login or Register  to view this content.
    and then determine any desired rounding
    Gary's Student

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1