+ Reply to Thread
Results 1 to 2 of 2

Rounding to the nearest quarter hour, spreadsheet attached

  1. #1
    Registered User
    Join Date
    04-12-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    15

    Rounding to the nearest quarter hour, spreadsheet attached

    I am working on a timesheet with 2 breaks, as long as you type AM or PM into the "in" and "out" cells you don't have to use military time. I need the hours to be reported in quarter hour increments though (14 min or less round down, 15 min or more round up) i.e. instead of 7.10, 7.00 would be reported, or instead of 7.30, 7.5 would be reported. I am having trouble with this.Timesheet Master with In and Out Formula 2 breaks.xlsx
    Thanks!

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Rounding to the nearest quarter hour, spreadsheet attached

    The basic concept is:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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