To reformat a culculated date/time round-up to the nearest ½ hour

M

Macgyver Goh

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
 
B

Bob Phillips

=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)
 
Top