+ Reply to Thread
Results 1 to 6 of 6

Round up a total to the next quarter hour

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    Delaware, OH
    MS-Off Ver
    Office 2019/Office 365
    Posts
    65

    Round up a total to the next quarter hour

    I currently have a total number of hours worked that I want to round to the next quarter hour. I don't want it to round back to the last quarter hour but forward. For example, even if I have a total time of 10.01 hours I would like it to round to 10.25 hours. I currently have this formula loaded in the total cell: =ROUNDUP(SUM(D6:D21),1) I also want to show the total number of hours and minutes in my total cell and not the decimal. I have attached a copy of the spreadsheet I am working with. Can anyone help me! Thanks,
    Attached Files Attached Files

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Round up a total to the next quarter hour

    I didn't download your file.

    Try something like this...

    A1 = 10.01

    =CEILING(A1,0.25)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    03-25-2013
    Location
    Delaware, OH
    MS-Off Ver
    Office 2019/Office 365
    Posts
    65

    Re: Round up a total to the next quarter hour

    That was helpful, Thank You. Right now when I have 2:00 pm to 3.58 pm it shows 1.97 hours. How can I get it to show the actual hours and minutes, total the column up and have it round to the next quarter hour?

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Round up a total to the next quarter hour

    Like this...

    A1 = 1.97

    =CEILING(A1,0.25)/24

    Format as h:mm

  5. #5
    Registered User
    Join Date
    03-25-2013
    Location
    Delaware, OH
    MS-Off Ver
    Office 2019/Office 365
    Posts
    65

    Re: Round up a total to the next quarter hour

    That did the trick. Thank you for your help. It is very much appreciated.

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Round up a total to the next quarter hour

    You're welcome. Thanks for the feedback!

+ 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. Enter Current Time then Round to Nearest Quarter Hour
    By tbstein99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2014, 05:07 PM
  2. [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
  3. [SOLVED] Round "X" number of minutes to quarter hour
    By BoardGuy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-18-2013, 01:55 PM
  4. 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
  5. Round total time to 1 hour multiples with a minimum of two
    By 2funny4words in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-06-2009, 03:02 PM
  6. 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
  7. [SOLVED] Need to round the time to the nearest quarter hour. Help
    By John in forum Excel General
    Replies: 1
    Last Post: 02-11-2006, 02:45 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