How to convert date time to decimal

[Anonymous]

How to convert date time to decimal so that the time can be presented on a trendline

I have this column (Completion Time):

I would like to see as a result: 5.58 for exampl if the completion time is 5:58 or some kind of alternative that allows me to use this field to presnet in a trendline completion time by month and calculate YTD completion time etc.

I tried using convert but I do not like the result I see:

Completion_Time = CONVERT('Daily Issues'[Completion time],DOUBLE)

Thanks!

[Anonymous]

thanks for feedback. Completion Time is just a column and not a measure and therefore power bi doesnt accept it in the formula..do you have another solution?

[Samarth_18]

Hi @Anonymous ,

You could create a column as below:-

Column = round(FORMAT('Table (6)'[Completion tme],"HH")&"."&FORMAT('Table (6)'[Completion tme],"NN"),2)

BR,

Samarth

[Anonymous]

Hi, I managed to create a new measure, however it looks like text. How can I convert it to double (round can not work as it is text):

Completion_Time = FORMAT(CONVERT('Daily Issues'[Completion time],DOUBLE),"HH")&"."&FORMAT(CONVERT('Daily Issues'[Completion time],DOUBLE),"NN")

[Samarth_18]

@Anonymous Please create a column only. I have updated the code as per your table name. Please try this:-

Column =
ROUND (
    FORMAT ( 'Daily Issues'[Completion_time], "HH" ) & "."
        & FORMAT ( 'Daily Issues'[Completion_time], "NN" ),
    2
)

Note:- I have considered the completion_time as column only.