Forum Discussion
Data type - Date Time to $
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.
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.
2 Replies
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.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
