Extracting specific data from Date and time strings

[John Norfolk]

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?

 

[Pete_UK]

=HOUR(A1)

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

Hope this helps.

Pete

 

[Mike H]

Hi,

With a date/time in A1 simply put =A1 in another cell and format as hh:mm

Mike

 

[Mike H]

Sorry,

Format as hh

Mike

Hi,

With a date/time in A1 simply put =A1 in another cell and format as hh:mm

Mike