View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ivory_kitten
 
Posts: n/a
Default Round up to whole hours

My formula calculates the time 2 hours from now and I need it to round up to
the next hour:

=NOW()+TIME(2,0,0)

I tried a few things but they didn't work!