Hi Orhan

Try this:

if your date is in A1, then Hour(A1). Then format the cell as "00"

Faisal...
On 26 Oct, 21:35, Orhan wrote:
Hi,

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