Thread: Round Date & Time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adams SC[_2_] Adams SC[_2_] is offline
external usenet poster
  
Posts: 9
Default Round Date & Time
I have a Start Date in Column A and Start Time in Column B. I know how to
add them togehter, but how do I add them together and round to the nearest
hour.

Example
Col A Col B
4/28/2010 5:23 PM

Results should be 4/28/2010 5:00 PM
Reply With QuoteReply With Quote