Changing minutes in text format into a time in hours

[ABill234]

Hi All,

Im very new to power bi and basically I have a sharepoint list which is linked to power bi. One of columns in sharepoint list which is titled Time in a text format see screenshot below: 

Can I convert this into hours in power BI? 

Please help!

[amitchandak · Accepted solution]

@Anonymous , if it is minutes

Hour = [time]/60

Or time format = time(0,[time],0)

[Anonymous]

You can select "Add Column", and place formula: 

Hours = DIVIDE([Time],60)

Or are you looking for something else?