Time Decimals

[Anonymous]

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.

It is 09:00 - 13:00 for reference. I was just wondering if anyone could spot whats wrong there and why its 59 minutes out?

I also have a lot of values with a minute incorrect e.g. 2:29 instead of 2:30. 

Thanks

Liam

[v-lili6-msft · Accepted solution]

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]

@v-lili6-msft 

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

Thanks for your help 🙂

[Anonymous]

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.