On Nov 6, 1:15*pm, Todd wrote:
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!

Could you convert the format of the cell to custom H? These seems to
drop all minutes from mine.
Thanks,
Jay