Divide time into hours
883125Apr 4 2012 — edited Apr 6 2012I have a table which has times(in seconds) when items are shipped to a particular location. The time extends from 6am in the morning to 6am next morning. This is how data looks below for one hour. I need to get the max value of time for each hour for each location. How can I do it? How can I divide the time into hours and get the max time?
time loc
22050 P
22065 P
22080 P
22110 P
22140 P
22155 P
22662 P
22692 P
22722 P
22767 P
23279 P
23309 P
23339 P
23369 P
23399 L
23429 L
23916 P
23976 L
24006 P
24066 P
24573 P
24588 P
24603 P
24618 P
24633 P
24693 P