Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date/Time as Duration

I have an Excel export that I've successfully converted the date/time to a duration I can use to calculate time spent on projects.   However, time over 24 hours in the data table shows "error".   Wha...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    what does the column [Minutes] represent to? 2.67 day? if so, you need to convert 2.67 day to minutes firstly, minutes = 2.67*24*60, then you can put it into the code template.

    for example,

     

     

    Best Regards,

    Community Support Team _Tang

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have tried multiple ways using the instructions provided, but still can not seem to get this to work.   Here is an example using the instructions.   I have tried multiple variations, including Extract data before/after in Power Query, to no avail.    I've attached screen shots of the source and the PBI output.

 

Any suggestions are greatly appreciated.