Everyone,
My first time here so I hope I detail my issue correctly.
I have a spreadsheet which has a date column and the dates are in the format MM/DD/YY HH:MM:SS.
I need to group the corresponding values in the the other columns based on 'hour of day' . In other words...
9/21/2011 14:11:45
9/21/2011 14:32:11
9/21/2011 17:01:03
should read as
9/21/2011 14:00
9/21/2011 14:00
9/21/2011 17:00
Is this possible?
Bookmarks