To reformat a culculated date/time round-up to the nearest ½ hour
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
|