Try
=ROUND(C1*24,0)
and format the cell as a number with two decimal places
This will display 13.00 as opposed to 13:00, is that a problem? If so post
back,
Regards,
Alan.
"Dr. Darrell" <[email protected]> wrote in message
news:[email protected]...
>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