Thanks:  0
Likes:  0

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

1. ## 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. ## Re: Rounding Up or Down depending on Start & End time

Cross-posted at: Rounding Up or Down depending on Start & End time

3. ## 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. ## 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.

6. ## Re: Rounding Up or Down depending on Start & End time

Originally Posted by jtakw
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...

## User Tag List

#### Posting Permissions

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