Our company makes socks. Socks are calculated by times (252 seconds)/(86400 seconds in a day) We need to see the percentage of production using the numbers accumulated over 3 shifts. Excel Formula reads like this, Run Time/86400/Total knit pairs over 3 shifts. This equation gives us the percentage of daily production. I can’t figure this out in Monday.
Hi Chris,
You need to add a formula column and the syntax in this case will be the same as in Excel.
Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.