View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RD RD is offline
external usenet poster
 
Posts: 13
Default Rounding off time

I have the following data: 7:45:00 AM I would like to round off to 8:00 (in
24 hour format). I thought it would be simple but I can't seem to get it.