Closed Thread
Results 1 to 2 of 2

How to make a time period a variable for this model? (automating the model)

  1. #1
    Forum Contributor
    Join Date
    02-04-2015
    Location
    Dallas,Texas
    MS-Off Ver
    excel 2013
    Posts
    191

    How to make a time period a variable for this model? (automating the model)

    I am trying to make the "Dwell Time(minutes)" in the "Home" sheet into a variable where future users can enter in their desired minutes and it will affect the whole model. The Increments can only be in 15 mins for example in the previous excel sheet we have 90 minutes Dwell time. So is there any way for the user to enter in different increments of 15 mins for that time period?

    Ignore the user walkthrough thats for the user to use when using this model. Also, I am returning total days of 60 in cell c11 in "home" sheet when it should be 61, is there a formula that can help with this or should we just put "+1" to make it always return one number higher?


    Can you guys please think of some ideas or how I can approach this?

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: How to make a time period a variable for this model? (automating the model)

    Thread has been posted in Commercial Forum.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Car make/model list
    By Charwood89 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-24-2020, 03:23 AM
  2. Replies: 1
    Last Post: 02-13-2015, 06:05 PM
  3. VBA Model : Two Stage Gordon Model
    By elaph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2014, 11:37 AM
  4. Create a model that will generate a column of numbers based on model parameters
    By tncanoeguy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 05:47 PM
  5. How to make orders in inventory model arrive at specifik date.
    By Chil24 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-04-2005, 05:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1