Need Excel formula

[sagar2295]

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).



[IMG alt="thumbnail image 1 of blog post titled











Need Excel formula












"]https://techcommunity.microsoft.com...405F965C5/image-size/medium?v=v2&px=400[/IMG]

Please not that here we are giving input in the same cell and getting outut in the same cell.

 

[Joe4]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Need excel formula
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.