I'm working on a worksheet to calculate the expected date & time of
complition base on the quantity, output rate of a production line which is
producing multiple products, I would like to round-up to the nearest ½ hr at
the end of each product. Is there any worksheet function that could be used
to manipulate the decimal value of the date/time to the nearest ½ hr or any
VBA function that could to the trick.

Thanks in advance for any advice given.

Regards,

Macgyver Goh

=ROUNDUP(A1*48,0)/48

or

=CEILING(A1,1/48)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Macgyver Goh" wrote in message
...
I'm working on a worksheet to calculate the expected date & time of
complition base on the quantity, output rate of a production line which is
producing multiple products, I would like to round-up to the nearest ½ hr
at
the end of each product. Is there any worksheet function that could be
used
to manipulate the decimal value of the date/time to the nearest ½ hr or
any
VBA function that could to the trick.

Thanks in advance for any advice given.

Regards,

Macgyver Goh

Thank you Bob for the info.

Regards,


"Bob Phillips" wrote in message
...