Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Time Decimals

Hi there,   I'm subtracting my times which Ive converted to decimals below.    Ive then ran the seconds through the Duration function from the community and its giving me 04:59 instead of 04:00. ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  Anonymous 

    I have test on my side, it works well

     

    The problem should be 'Room Utilisation'[34] in your formula. Why do you use [34] instead of [Duration in seconds] in your formula?

    Could you please share your sample pbix file for us to have a test, that will be a great help.

     

    Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Anonymous 

I have test on my side, it works well

 

The problem should be 'Room Utilisation'[34] in your formula. Why do you use [34] instead of [Duration in seconds] in your formula?

Could you please share your sample pbix file for us to have a test, that will be a great help.

 

Regards,

Lin

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-lili6-msft ,

     

    I have a formula which subtracts the time decimals and gives the result. The [34] just multiplies that by 86400.

     

    Another example below. 0.6667 - 0.375 = 0.2917 * 24 should equal 7.0008 and be 7 hours. Below is showing 07:59.

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-lili6-msft 

     

    My apologies, two IF statements were causing it to give an incorrect value to the hours function.

     

    Thanks for your help 🙂