Forum Discussion
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.
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
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
3 Replies
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
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.
My apologies, two IF statements were causing it to give an incorrect value to the hours function.
Thanks for your help 🙂