On Oct 27, 12:06 am, "Otto Moehrbach" wrote:
Say your date and time are in A1, as before. In another cell, type, without
quotes, "=HOUR(MOD(A1,1))"
This will get you the hour. If you pastespecial - Values this to another
cell you will get the hour only. HTH Otto"Orhan" wrote in message

ups.com...

Hi,

It shows correct hour "02" but when I copy-pastevalues the cell value
is still "2:25:46 AM"

Thanks,
That did the trick.