Extract hour from date
Format the cell Custom - hh. That is, click Format - Cells - Number tab -
Custom, type hh for type. 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"
|