Previously I asked the following question and got an answer that I thought
was working for me but is slightly different than my meaning... I wrote:
I have a list of date/time values which I plan to use text-to columns to
strip away the time.

Next, I need to convert these time values into half hour interval values
but
don't know how to do this.

For example
Original Value Converted Value
23:16 23:00
09:56 09:30

So, you can see I'm converting the time to the last half hour that passed.
Can anyone suggest a formula or method to simplify this for me? Many
thanks
in advance for any assistance.

The answer I got was:

"George Nicholson" wrote:
=TIME(HOUR(A2),IF(MINUTE(A2)<30,0,30),0)

Note that this will also strip away date values as well.


This works for converting times to whole hour intervals, but what I need is
half hour intervals. Can anyone suggest a minor modification that will give
me half hours instead of whole hours? Thanks!