In reply to Simon Yip.

One workaround in the designer would be to use your datetime value to create a date hierarchy. Then create a calculated data item consisting of the timepart of your datetime value. You can then duplicate your timepart data item with an hour format and another with an hour,minutes format. Then add these new data items to your date hierarchy.