ExcelBanter - Round Date & Time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Round Date & Time (https://www.excelbanter.com/excel-discussion-misc-queries/262641-round-date-time.html)

Adams SC[_2_]

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

Jim Thomlinson

Round Date & Time

=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

All times are GMT +1. The time now is 06:53 AM.