Change 2:34:45am to 2

[Osaseme]

What is the formula to get only the hour? I have used left in the past but this time it is not working. I tried to use hour but to no avail. When I use hour, I get 0:00:00. Please help.

 

[Ratan Bhushan]

try to use =text("ref","hh")

 

[Ratan Bhushan]

I am uploading the file it worked fine u need to clear previous formatting thats it

 

[Somendra Misra]

Hi,

If you just want to show hour in cell you can use custom number format of hh on the cell. This way your data will not be lost.

Regards,

 

[Osaseme]

Thank you all. Problem solved.