Thread: How do I round time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ana Ana is offline
external usenet poster
  
Posts: 44
Default How do I round time
I would like to know how to round five minutes to an hour and five minutes
after the hour to the nearest whole hour. (ex. round 7:55 and 8:05 to 8:00)

Thanks,

Ana
Reply With QuoteReply With Quote