+ Reply to Thread
Results 1 to 7 of 7

Rounding Time to the Nearest Quarter Hour

  1. #1
    Registered User
    Join Date
    03-06-2005
    Location
    Pottsboro, TX
    MS-Off Ver
    MS 365 - Version 2208
    Posts
    83

    Rounding Time to the Nearest Quarter Hour

    ..............Delete
    Attached Files Attached Files
    Last edited by tacnola; 03-06-2023 at 12:33 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Rounding Time to the Nearest Quarter Hour

    Please update your profile with your actual XL version please, as answers are tailored to the XL version. thx

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Rounding Time to the Nearest Quarter Hour

    Try

    in H16

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  4. #4
    Registered User
    Join Date
    03-06-2005
    Location
    Pottsboro, TX
    MS-Off Ver
    MS 365 - Version 2208
    Posts
    83

    Re: Rounding Time to the Nearest Quarter Hour

    I have updated my excel version. Thank you.
    Last edited by tacnola; 03-05-2023 at 05:37 AM.

  5. #5
    Registered User
    Join Date
    03-06-2005
    Location
    Pottsboro, TX
    MS-Off Ver
    MS 365 - Version 2208
    Posts
    83

    Re: Rounding Time to the Nearest Quarter Hour

    Thank you for your assistance.
    When I enter that formula into Cell H16 I get the result of .020833333 and H17 .197916667

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Rounding Time to the Nearest Quarter Hour

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

    (Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Registered User
    Join Date
    03-06-2005
    Location
    Pottsboro, TX
    MS-Off Ver
    MS 365 - Version 2208
    Posts
    83

    Re: Rounding Time to the Nearest Quarter Hour

    Quote Originally Posted by AliGW View Post
    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

    (Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
    I let this question sit for roughly 24 hours on the MREXCEL.com forum before I posted to this site. Due to the comical response of "Is this homework" I thought the algorithm was messed up and this post would fall into the realm of 'it has been answered. That is when I went to this site for assistance.

+ 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. Rounding military times without colons to the nearest quarter hour
    By JoERuck14 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-20-2020, 07:32 PM
  2. [SOLVED] Rounding time to the nearest quarter hour
    By allwrighty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-23-2014, 02:18 PM
  3. Rounding to the nearest quarter hour, spreadsheet attached
    By jrace in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-21-2013, 04:46 AM
  4. Excel 2007 : Rounding to the nearest quarter hour
    By rski in forum Excel General
    Replies: 1
    Last Post: 06-15-2010, 07:12 PM
  5. 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
  6. Rounding to nearest quarter hour?
    By StargateFan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-18-2005, 02:05 PM
  7. Rounding times to nearest quarter of an hour
    By Julia Osborne in forum Excel General
    Replies: 7
    Last Post: 04-27-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