Extracting Hours from a date time 'string'

[rachew]

Hi,

In a cell I have a date & time e.g. 01/01/2007 02:02:02 what I am seeking to do is in the next cell just insert the hour i.e. the first "02".

Does anyone know a formula to do this?

[arthurbr]

Have a look at the HOUR function

HTH