+ Reply to Thread
Results 1 to 3 of 3

Timesheet: How to make a running total, and can you have "negative? time?

  1. #1
    Registered User
    Join Date
    02-10-2012
    Location
    Cowtown Canada
    MS-Off Ver
    Excel 2010
    Posts
    50

    Timesheet: How to make a running total, and can you have "negative? time?

    I am working on a spreadsheet to track hours worked. It is an 8 hr day. I want there to be a running total, but when less than 8 hrs are worked and the total goes below 8 hrs per day (as in when you have no "banked time" it will not display negative or owned time. Also, it doesn't seem to want to skip over the weekends for me. Please see the attached sheet.

    Thanks!!!


    timesheet.xlsx

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Timesheet: How to make a running total, and can you have "negative? time?

    No negative time as far as I know. Have made a modification to your file.

    Have a look and see if this could be of help.

    Alf
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-10-2012
    Location
    Cowtown Canada
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Timesheet: How to make a running total, and can you have "negative? time?

    Thanks. It gets it most of the way...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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