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