I want to work out how long it takes a number of work items to take, for example if it takes 40 minutes to create 1 laptop build, I would like to input the number of laptop builds into a cell and it auto populates another cell with the answer.
For example, if I entered 2 into the input cell I would like an answer cell to show 1:10.
If anyone can advise how to do this I'd be really grateful.
Thanks
A1 = input: no. of units
A2 = input: time per unit
A3 = A1 * A2
//total amount of time to fabricate
Like that...?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Yes like that but ideally I'd like the time per unit cell A2 not to be seen. So I input the no. of units into A1 and it goes off and calculates the time per unit to give the answer into A3.
Thank you
If you know the time per unit, let's say 40 minutes
in A3
=A1* "0:40"
Format A3 as custom [h]:mm
Do you know how to do that?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks Ben and Chemist.
Chemist, your suggestion is exactly what I was after, thanks v much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks