+ Reply to Thread
Results 1 to 4 of 4

sum and subtract time at the same time from a running total

  1. #1
    Registered User
    Join Date
    08-30-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    sum and subtract time at the same time from a running total

    I have a spread sheet where extra time worked in entered in to two columns, start extra time and finish extra time (column A 17:30 Column B 18:15). This then is totaled in a running total in hours and minutes in another cell. On the same spreadsheet, the employee enters time in two columns when finishing early and time rostered to finish when leaving early to use the time owed. This is then calculated as another column as a running total. I need the running total of time taken subtracted from the running total of time accrued. I cannot figure out how to do this.
    I have attached the work book
    any and all help will be greatly appreciated
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: sum and subtract time at the same time from a running total

    Hi,

    Use this formula in C5:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Hope this helps

  3. #3
    Registered User
    Join Date
    08-30-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: sum and subtract time at the same time from a running total

    Wow, so simple yet does just what I want it to do. Thank you so much for your help

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: sum and subtract time at the same time from a running total

    You're welcome!

    Please don't forget to mark this thread as solved and please click on the * next to my post to say thanks

+ 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. Replies: 2
    Last Post: 01-18-2013, 11:47 AM
  2. [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
  3. 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
  4. Running Total for Calculating Sick Time
    By Mart1n in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2009, 09:17 PM
  5. [SOLVED] Keeping a running time total
    By Jim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2006, 12:15 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