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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top