Results 1 to 9 of 9

VBA round up & down by 7 minutes on time

Threaded View

  1. #1
    Registered User
    Join Date
    11-17-2015
    Location
    Nitra, Slovakia
    MS-Off Ver
    O365
    Posts
    69

    VBA round up & down by 7 minutes on time

    Hi all,

    I tried to google search this macro but I cannot find anything close to what I want:

    So I have a workbook for my clock-ins and outs, and from next month we're changing format and instead of rounding up&down by 15 minutes as it was until now, it will be rounded by 7. It was easy to calculate but now I just don't wanna bother with it each day.

    So clock-ins and outs are going to be rounded the same way:

    If I clock-in / out @ 7:07 or 6:53 it will go to 7:00, but if I clock @ 6:52 that will go to 6:45 and if @ 7:08 that will go to 7:15

    Hope this is clear enough,

    Cell range is: B3:C33

    Thanks
    Last edited by Martines91; 06-14-2019 at 01:11 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Round Time to 30 minutes
    By Shiv in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2014, 05:11 AM
  2. Sum time then round to nearest 5 minutes
    By Trig79 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-27-2013, 11:02 AM
  3. Round up to whole minutes
    By Rocky_bear in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-12-2013, 10:30 AM
  4. How do I round minutes up and down?
    By Agent007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-08-2013, 10:50 PM
  5. How to covert and round up time to minutes
    By ramnadh in forum Excel General
    Replies: 3
    Last Post: 12-08-2010, 08:17 AM
  6. Converting hours and minutes in military time to minutes
    By Argile79 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-13-2010, 02:42 PM
  7. [SOLVED] Round up a time to the next 15 minutes
    By Frederick Chow in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-05-2006, 06:41 AM
  8. How to round down to nearest 5 minutes, time calc?
    By StargateFanFromWork in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-18-2005, 05:05 AM

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