Mean Time Between Two Dates from Form Submission
I'm attempting to find the average downtime of an asset between dates from a form submission for the month. For example below, I need to find the number of days between the "OOS Tag Removal Date" and "Date OOS Tag Applied", based only on all entries for "Asset ID" FD-001201 where the "Reason for OOS" is Failure, then average that number for each month. Honestly, I don't even know the best way approach this.
That average will then be provided on my metric sheet below under the MTBF for each month to trend reliability:
Any help setting up this formula would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!