=HOUR(A1)

if your date/time is in Excel format and in A1.

Hope this helps.

Pete

On Sep 24, 9:47*am, John Norfolk wrote:
Hi,

I want to extract the hours from a date time cell so that I can group data
that occured in the same hour.

How can I do this?
--
Thanks
John