create time of day dimension

[johndoub]

i have a field showing date and time.

see attached. what is the formula to create a dimension for sales by hour for a given date range?

thanks.

John Doub