+ Reply to Thread
Results 1 to 2 of 2

Enter Current Time then Round to Nearest Quarter Hour

  1. #1
    Registered User
    Join Date
    03-20-2014
    Location
    Grand Rapids, MI
    MS-Off Ver
    Excel 2013
    Posts
    1

    Enter Current Time then Round to Nearest Quarter Hour

    I am new to Excel programming and would like some help. I work at a facility where we care for adults with disabilities and we need to record times that clients arrive and leave. I created an attendance check-in sheet that needs the current time entered quickly. Is there code that will allow staff to double click on a cell and have the current time entered and rounded to the nearest quarter hour?
    Any help would be greatly appreciated. Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Enter Current Time then Round to Nearest Quarter Hour

    Do you use standard time or military time?

    Please Login or Register  to view this content.
    Should take care of it in standard time.
    Last edited by Solus Rankin; 03-26-2014 at 05:37 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] To round a sum of Nums to nearest quarter of an hour from numbers that are themselves sums
    By Webmastereol in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-06-2013, 03:01 PM
  2. where to put formula to round hoursbto nearest quarter hour
    By MAINTENANCEMANCINCY in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-27-2012, 03:36 AM
  3. [SOLVED] How do I round time to the nearest quarter of an hour
    By Meghan in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 07-07-2006, 01:40 PM
  4. Replies: 1
    Last Post: 02-11-2006, 02:45 AM
  5. Round time to nearest quarter hr
    By John in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-16-2005, 06:06 PM

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