Round Date & Time

  • Thread starter Thread starter Adams SC
  • Start date Start date
A

Adams SC

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
 
Back
Top