Hi

One way
=IF(MINUTE(A1)<30,FLOOR(A1,TIME(0,30,0)),CEILING(A 1,TIME(1,0,0)))

--
Regards

Roger Govier


"Dr. Darrell" wrote in message
...
I have a worksheet that I enter time values into individual cells:

A1 = 6:00
B1 = 12:00
C1 = 12:45
D1 = 17:15

When I enter these values, I would like some of the values to round to
the
next higher "30 minute increment" such as Cell C1 should become 13:00.

I would also like some of the values to round back to the next lower
"30
minute increment" such as Cell D1 should become 17:00.

What function should I use, or what code should I type for this.

Darrell