Powerpivot incorrect format [H]:mm

[shonaart]

Hi
I have linked a Table to Powerpivot and I have some columns ( fields) that have hours & minutes format [h]:mm ( NOT Time formate ie: 13H55 ).

When I linked it the the hours & minutes came up as Date ??

When I select the field in powerpivot and want to change the format , there is only the TIME ( 13H50 ) option and not hours & minutes ??

I need the hours & minutes , and not a decimal conversion.

Do you know what formate in Excel ( [H]:MM ) equals it in Powerpivot.

Thanks

 

[PWF999]

I have having a similar problem I am summing the time in a measure and only allows values less than 24 hours. Any suggestions?