View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Ratzel[_2_] Jon Ratzel[_2_] is offline
external usenet poster
 
Posts: 16
Default Rounding time of day up to fall in during work hours

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!