+ Reply to Thread
Results 1 to 8 of 8

start stop times issues in excel

  1. #1
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    start stop times issues in excel

    Test 6.xlsm


    I back needing some more help. I have attached my form. currently i have it that it calculates time by subtracting NOW() from the first start time minus break time. this allows all lines to be updated any time any one hits start or stop. what i need to do now is add a complete button on each line that will stop that line from updating.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: start stop times issues in excel

    Wouldn't this be better:

    =IF(B5="",0,MOD(MAX($C$5:$C$31)-B5,1))-E32
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: start stop times issues in excel

    again I am a rookie, how would this work different

  4. #4
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: start stop times issues in excel

    No this doesn't work for what I am trying to accomplish. Each line will clock in and out several times. and the total time picking will accumulate on each line as they go. problem is when one line finishes currently using the formula I have it does not stop adding time. I need a end batch button on each with a macro i am guessing that will stop this cell from adding more minutes.

  5. #5
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: start stop times issues in excel

    Then perhaps even more simply:

    =IF(B5="",0, SUM($D$5:$D$31))

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: start stop times issues in excel

    I did a Google search for Stop Watch for Excel and found this site with several free stopwatches for Excel. Perhaps one of them will suit your needs.

    http://www.windows8appstore.com/sear...pwatch%20excel
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  7. #7
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: start stop times issues in excel

    no not what im looking for but thanks

  8. #8
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: start stop times issues in excel

    I would of thought there might be a macro that i could attach to a button and when i hit it on a line it would stop running that formula.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Start stop time in excel
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-17-2013, 10:51 AM
  2. Calculate hours worked from dropdown list for start and stop times
    By vanchopski in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-02-2012, 05:22 PM
  3. Excel 2007 : Headcount Based on Date & Start/Stop Times
    By ibspayroll in forum Excel General
    Replies: 8
    Last Post: 05-10-2011, 05:28 PM
  4. Match Start & Stop Times
    By dreicer_Jarr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-09-2010, 10:46 PM
  5. How to chart start and stop times
    By tresscott in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-10-2005, 06:06 PM

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