Hi -
I need to create a formula to to round the time to the nearest quarter hour (up or down).
For example: In Cell A2 the time is shown as 09:13 AM / In cell B2 I want it to convert the value in A2 to display as 09:15 AM
Thanks for your help.
Hi -
I need to create a formula to to round the time to the nearest quarter hour (up or down).
For example: In Cell A2 the time is shown as 09:13 AM / In cell B2 I want it to convert the value in A2 to display as 09:15 AM
Thanks for your help.
=mround(a2,"0:15")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
This rounds up.
Formula:Please Login or Register to view this content.
Both Cells need to be formatted to display time.
Last edited by mehmetcik; 12-23-2014 at 02:14 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thank you both martindwilson and mehmetcik. Both solutions work.
Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks