Extracting specific data from Date and time strings
 

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

Extracting specific data from Date and time strings
 

=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

Extracting specific data from Date and time strings
 

Hi,

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

Mike

"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

Extracting specific data from Date and time strings
 

Sorry,

Format as hh

Mike

"Mike H" wrote:

Hi,

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

Mike

"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