Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Rounding Up or Down depending on Start & End time

  1. #1
    New Member
    Join Date
    Jun 2014
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Rounding Up or Down depending on Start & End time

    I have a spreadsheet that I use to Input a Start Time and End Time in one column and the decimal value to that time in another column.
    This is what I use for getting the total hours per day:=IF(D2="","",D2-C2) Pretty simple.
    This is what I use to get the Decimal value total hours per day: =IF(D2="","",HOUR(E2)+MINUTE(E2)/60)
    My problem is how to round up or down based on the "Conversion Table - Minutes to Decimal Hour". This is a table 1 thur 60 with the decimal value .02 thru 1.0
    Lets say your Start time is 7:00 am and End time is 4:11 pm which is 9 hours 11 minutes or (9 hours .18 decimal minutes) which would roundup because its closer to 4:15 than 4:00.. Each 15 minutes which ever is closer.
    Don't know if I can post the "Conversion Table" with this post. It is a common table on the internet.
    Thanks so much for any help!!!

  2. #2
    Moderator Macropod's Avatar
    Join Date
    Aug 2007
    Location
    Canberra, Australia
    Posts
    3,141
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Rounding Up or Down depending on Start & End time

    Cross-posted at: Rounding Up or Down depending on Start & End time
    Please read our policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-a...rum-rules.html
    Cheers
    Paul Edstein
    [MS MVP - Word]

  3. #3
    New Member
    Join Date
    Jun 2014
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Rounding Up or Down depending on Start & End time

    Sorry, I did not know we could not post to other totally separate forums that have nothing to do with this one. I only was opening more possibilities for more answers. Which I got my answer at another web site not this one. If I was still waiting on this site I'd never get an answer. Is that fair? If anyone would like the answer its =MROUND(cell #, "0:15") Please remove me from this site so there will not be any more confusion. Thanks, Richard

  4. #4
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,011
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Rounding Up or Down depending on Start & End time

    Hi,

    No one said you can't post to this forum if you had already posted elsewhere. It's just proper forum etiquette to post the link where you also posted the question elsewhere, so that potential helpers can refer to your other posting to see what has been suggested, working, not working, etc., so that they won't waste their time if it's already been tried or solved.

    Refer to Macropod's post #2 regarding forum rule #13.
    Last edited by jtakw; Jun 21st, 2016 at 08:38 PM.

  5. #5
    New Member
    Join Date
    Jun 2014
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Rounding Up or Down depending on Start & End time

    Please do not send me any more replies. Please!

  6. #6
    Moderator Macropod's Avatar
    Join Date
    Aug 2007
    Location
    Canberra, Australia
    Posts
    3,141
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Rounding Up or Down depending on Start & End time

    Quote Originally Posted by jtakw View Post
    It's just proper forum etiquette to post the link where you also posted the question elsewhere, so that potential helpers can refer to your other posting to see what has been suggested, working, not working, etc., so that they won't waste their time if it's already been tried or solved.
    For some people, that seems to be too much to ask...
    Cheers
    Paul Edstein
    [MS MVP - Word]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •