Rounding time of day up to fall in during work hours
That seems to be rounding down or up all my times to 8:30AM of the same
business day regardless of the time of day I originally had. This part works
perfect if my original time is before the 8:30AM start of the business day,
but what if my original time is after 5:00PM?
Thanks for the help, I'm getting close!
Jon
"CLR" wrote:
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!
|