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:
> 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!