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

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

=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

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

Thank you Bob for the info.

Regards,


"Bob Phillips" wrote in message
...