Time calculation assistance need...., maybe....

[Guest]

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

 

[Guest]

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

 

[Dave O]

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