Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Aug 2008
    Location
    Daytona Beach, Florida, USA
    Posts
    42
    Thanks
    3
    Thanked 0 Times in 0 Posts
    This may be a simple fix, but I am trying to round the current time ,Time(), to the nearest 15 mins within a macro.

    The macro contains Action = SetValue, Arguments={SIGN IN],Time()
    The macro is being used on a form after a click on the Sign in Check box, the time is updated in a Sign In Text Box.

    I have not used macros very much in the past and maybe using the wrong action.

    Any help is appreciated.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Brandy,

    See this thread.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Lounger
    Join Date
    Aug 2008
    Location
    Daytona Beach, Florida, USA
    Posts
    42
    Thanks
    3
    Thanked 0 Times in 0 Posts
    mround does not show as a Access Function when I try to update the expression.

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Yes the link that Retired Geek gave you pointed to an Excel thread, and mround is an Excel function.

    I was going to point you to a recent thread on this subject, but I realised that this thread was yours. So what are you asking here that is different to that thread. Do the suggestions given there not work?

    In your previous thread I included a link to Allen Browne's rounding page that had a function for rounding time.
    Regards
    John



  5. #5
    Lounger
    Join Date
    Aug 2008
    Location
    Daytona Beach, Florida, USA
    Posts
    42
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I couldn't get the first ones to work, but it worked with the int formula.

  6. #6
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    John,

    Great link...thanks. 1 Thumbs up!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  7. #7
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Thanks..but it is Allen Browne that deserves the Thumbs Up!
    Regards
    John



Posting Permissions

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