Prev: Active X text box control
Next: Calculation of Age
From: Adams SC on 28 Apr 2010 13:56
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
From: Jim Thomlinson on 28 Apr 2010 14:05
=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
 | 
Pages: 1
Prev: Active X text box control
Next: Calculation of Age