Forum Discussion

MCALDERON's avatar
MCALDERON
Frequent Visitor
4 years ago
Solved

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 Co...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    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.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

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.