Forum Discussion
Get total hours functioning in a period
Hi josevarelac
Is this what you want?
this is dynamic, please check.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi josevarelac
Is this what you want?
this is dynamic, please check.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft MAggi, first of all thank for your time a dedication on this problem. Your aproch is all most perfect, but there are some flaws, the Working Time for the machine A, assuming Initial Date= 7/12/2019 and Final Date = 13/1/2020, is 4.267 hours.
The calculation of that number is showned in this image:
And the logic of that number is the following:
The same criteria applies to the machine B, also remember that the Final Date can be in between to failures to the working time is 0.