View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default 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"