+ Reply to Thread
Results 1 to 3 of 3

Running total of time

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    North Yorkshire
    MS-Off Ver
    Office 365
    Posts
    1

    Running total of time

    Hello

    We use a FLEX system at work so what I am trying to achieve is a running total when I add a negative or positive value in minutes (00:00)

    Please see manual example on the attached sheet.

    The flex balance should never exceed +06:00 or -06:00 hours.

    Hope this can be done, and thanks in advance.

    Johno
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Running total of time

    The problem is that Excel can't work with negative time.

    See if this work around is an workable option for you.

    See the attached fie.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Running total of time

    If you are limited to using Excel and only Excel for this, then oeldere has you covered. I would only add, at the risk of irritating Microsoft and an Excel community, that other spreadsheets are not limited in this way -- they have no trouble entering, using, and displaying negative elapsed times (and dates going back to 1 CE [Gregorian] if you ever become interested in that). In LO Calc, for example, I can convert your times from text to number, then simply add them up (=E2+D3 copied down). I don't know why Microsoft has not yet made this simple "bug" fix to Excel after 30ish years, but they haven't bothered. Just one of my occasional plugs for spreadsheets outside of Excel.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. sum and subtract time at the same time from a running total
    By simonood in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2013, 02:10 AM
  2. Replies: 2
    Last Post: 01-18-2013, 11:47 AM
  3. [SOLVED] Calc a running total of time elapsed from a timestamp
    By AWilson012 in forum Excel General
    Replies: 3
    Last Post: 07-11-2012, 03:19 PM
  4. Replies: 4
    Last Post: 04-03-2012, 02:01 PM
  5. Formula for obtaining the total running time from the time code
    By hbsunshine in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 03-06-2011, 05:26 AM
  6. Running Total for Calculating Sick Time
    By Mart1n in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2009, 09:17 PM
  7. Keeping a running time total
    By Jim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2006, 12:15 PM

Tags for this Thread

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