Hi all...,

I have a range of various times arranged in a single column..., <D2 =
8:29:46 AM, <D3 = 9:57:59 AM, <D4 = 1:38:40 PM..., etc. Using a formula or
function in the column to the right, I want capture and display just the hour
of these times..., <E2 = 8:00 AM, <E3 = 9:00am, <E4 = 1:00 PM.

thanks - D

Try =HOUR(D2)/24
and format to the time format you want.

"Denniso6" wrote:

Hi all...,

I have a range of various times arranged in a single column..., <D2 =
8:29:46 AM, <D3 = 9:57:59 AM, <D4 = 1:38:40 PM..., etc. Using a formula or
function in the column to the right, I want capture and display just the hour
of these times..., <E2 = 8:00 AM, <E3 = 9:00am, <E4 = 1:00 PM.

thanks - D

The formula in E2 would be
=HOUR(D2)/24
....and format for time.