Hi,

I'm working on a report that I need to convert a range of time into only 1
hour increments. Here is an example.

A1 Need new cell to show
10:19 AM 10 AM
3:54 PM 3 PM
11:23 AM 11 AM
7:44 AM 7 AM

The new cell will not need the minutes, just the hour in which the event
occured. I have over 40,000 cells that need to be converted, so anything
simple would be great.

Thanks!