Date & Time field return just the hour

[shonaart]

Hi
I have a date & Time field . ( 2011/06/10 13:30 ) in column A.
I want a formula to return in column B only the hour of that day. So for example 2011/06/10 13:30 will be 13:00 and 2011/06/10 14:13 will be 14:00 etc.

It must just look at the field and return that hour of the day , not including the minutes.

Thanks
Vaughan

 

[VoG]

Try

=HOUR(A1)/24

Format as hh:mm