Convert Time To Half Hour - Pt 2 - OOPS!

B

BenS

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

The answer I got was:

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

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

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

BenS

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

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
 
Top