Convert hh:mm to decimals

[hetal247]

Hi,

I have been looking for some help online but not getting there answer to my query.

I want to convert time into decimals. I know you can do this in excel by multiplying the time by 24 and format the cell to decimal number but this logic does not work in Power BI.

How do you convert 01:30 to 1.5 so i works for all time formats i.e 00:12 to 0.2, 00:30 to 0.5

I am looking to convert visit duration that is currently displayed in time format to decimal number and then want to sum the total duration for any given week.

Any help is much appreciated.

kind regards

Hetal

[Mahesh0016 · Accepted solution]

>> create Column
Column 2 = HOUR([Column])+MINUTE([Column])/60+SECOND([Column])/60/60 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[hetal247]

@NikhilChenna @Mahesh0016 

thank you both. this worked and does what i was after.

[NikhilChenna · Accepted solution]

Hi @hetal247 ,

I think the by creating this below custom column your issue will get resolved,

Decimal column = HOUR([Datetime])+MINUTE([Datetime])/60+SECOND([Datetime])/60/60

Regards, 
Nikhil Chenna 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Mahesh0016 · Accepted solution]

>> create Column
Column 2 = HOUR([Column])+MINUTE([Column])/60+SECOND([Column])/60/60 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!