You're right David, I didn't read close enough.........good catch.

Vaya con Dios,
Chuck, CABGx3



"David Biddulph" wrote:

And what result does that give for the OP's second example, Chuck?
--
David Biddulph

"CLR" wrote in message
...
Maybe this will help...........

=MAX(A1,INT(A1)+0.3541666667)

Vaya con Dios,
Chuck, CABGx3

"Jon Ratzel" wrote:

I'm working with adding and subtracting time and need a way to round a
date/time up to the next business day which runs 8:30AM-5:00PM. So, if I
have
a cell that has 1/25/08 7:36 AM (which is a Friday) I would need it to
round
to 1/25/08 8:30 AM. However if the time is 1/25/08 7:36 PM I would need
it to
round to 1/28/08 8:30 AM which is the start of the next business day. Can
someone help?

Thanks!