Jun 07 2022 01:22 PM
Hello Guys,
I need excel formula for my below problem.
Here, Step involved:
I need "Total Cycle Time".
1) When we click the cell "No of items produced", it will ask me to enter Quantity
2) Once I enter "No of items produced" (B2) ( it will calculate the cycle time according to the below formula in the backend)
3) Then, it will show me the "Total Cycle Time" in the same cell (B2).
Please not that here we are giving input in the same cell and getting outut in the same cell.
Jun 07 2022 01:46 PM
I'm not sure this is a good idea. See the attached demo workbook. You'll have to allow macros.
Jun 07 2022 01:52 PM
Jun 07 2022 02:13 PM
If B2 contains a formula, you would overwrite it the moment you enter a value...