Time calculation assistance need...., maybe....
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
|