Convert Time To Half Hour - Pt 2 - OOPS!

[BenS]

Previously I asked the following question and got an answer that I thought

The answer I got was:

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

 

[Toppers]

Try:

=TIME(HOUR(A2),INT(MINUTE(A2)/30)*30,0)

HTH

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[BenS]

Awesme! Both solutions worked so thank you both. This is very helpful
information to know.

 

[Pete_UK]

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