How do I round the product of an equation to the nearest whole number?

I also need to round a figure representing a time length (1.64hrs.) up to
the nearest half hour (2 hrs.).

Thanks for any help.

= for equation ROUND ( B2 Location of number to be rounded , 0 Zero places.
Rounds to the nearest whole number .5 and up round up etc
=ROUND(B2,0)
"RayL" wrote:

How do I round the product of an equation to the nearest whole number?

I also need to round a figure representing a time length (1.64hrs.) up to
the nearest half hour (2 hrs.).

Thanks for any help.

=round(num,0)

=roundup(time*2,0)/2

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RayL" wrote in message
...
How do I round the product of an equation to the nearest whole number?

I also need to round a figure representing a time length (1.64hrs.) up to
the nearest half hour (2 hrs.).

Thanks for any help.