=A2 + ROUND(B2*24, 0)/24
--
HTH...

Jim Thomlinson


"Adams SC" wrote:

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