Date & Time to show only 24Hr format

[shonaart]

Hi
Column A : Is formated as Date & time (example : 2011/03/23 23:34 )
Please can you tell me how I can look at come A : and show the 24 hour time in column B: as 23
I do not want to see the Date and the minutes. I tried formated column B : to HH with no MM
but when I pull it into the Pivot table and I want to group the Hours , the pivot table still sees the minutes.

I am trying to group my "times" in hours in my pivot table , for example I want my times to be somthing like this : 13, 14, 15 etc

Thanks
Vaughan

 

[jasonb75]

Assuming first date / dite in A2

=HOUR(A2)

then fill down.

 

[shonaart]

Thank you, you star

 

[GlennUK]

When you group by hours in a PivotTable ( right click the Time field, Group, by Hour ) it just shows the hours.