Data type - Date Time to $

[MCALDERON]

Hi, 

I need a little help, I have a Custom column "Run Time" that has the operation "End - Start" and the result is: 0.00:43:00. With this result I need to create a new custom column "Run Time Cost" with the operation "Run Time * 4" this 4 means 4$, so I need the result to be shown as Fixed Decimal Number. 

How can I solve this one? Thanks in advanced. 

[v-henryk-mstf · Accepted solution]

Hi @MCALDERON ,

According to your description, customize a column, first find the share of the start-end column in the day, and then multiply the result by 4 to get the time cost.

days_ = (MINUTE('Table'[Column1])/(24*60))*4

If the problem is still not resolved, please describe your needs again, and the results that are expected to be provided. I will get back to you as soon as possible.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

Convert your duration column to a decimal number, which will be in days.  From there, multiply by 24 to get hours and then multiply by 4 to get your result.

Pat