There seem to be a lot of posts like this now - showing up as a new
thread, but in answer to another thread. So, I have to reply to you,
Sandy, though my response is aimed at the OP, because his post is not
showing other than as quoted text in your reply.

Anyway, George's formula worked fine for me.

Pete

On Mar 29, 8:37 pm, "Sandy Mann" wrote:
As I posted in your previous post try:

=FLOOR(A2,0.5/24)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk

"BenS" wrote in message

...



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!- Hide quoted text -

- Show quoted text -