1. If you enjoy the forum please consider supporting it by signing up for a NES Membership  The benefits pay for the membership many times over.

  2. Dismiss Notice

Excel Question

Discussion in 'Off-Topic' started by C. Stockwell, Aug 14, 2019.

  1. C. Stockwell

    C. Stockwell

    Joined:
    Dec 12, 2018
    Messages:
    1,221
    Likes Received:
    1,009
    Location:
    RI
    I'm doing a fall externship (meaning for academic credit) this upcoming semester. I have to complete 540 hours of work to receive credit. How do I set up a spreadsheet that allows me to enter in my clock in, lunch out, lunch end, and clock out hours every day without me having to manually calculate the hours I worked, and then subtract my daily hours from the total of 540?

    For example, let's say I clock in at 8:30, lunch out at 12:30, my lunch ends at 1pm, and I clock out at 5pm. I want Excel to calculate that I worked eight hours that day and then subtract 540 - (daily hours worked cell) = hours remaining of externship (540 - daily sum earned, which here is 8 = 532). Then the next day, 532 - 8 = 524, and so on.
     

  2. wilson911

    wilson911

    Joined:
    Jan 11, 2015
    Messages:
    932
    Likes Received:
    1,346
    Location:
    Southwest NH
    Use an app like TimeSheet then export as a .csv and open in excel.
     
  3. jpm

    jpm NES Member

    Joined:
    Jan 9, 2013
    Messages:
    5,129
    Likes Received:
    966
    open Excel and click File - New. There's hundreds of templates available to you there. You can click on Planners and Trackers for example or type in a keyword to search for particular templates e.g. 'timesheet'.
     
  4. Stryker

    Stryker NES Member

    Joined:
    May 7, 2010
    Messages:
    4,266
    Likes Received:
    1,505
    Location:
    Nashoba Valley, MA
    I attached a basic sheet that does what you want
    Fill in the cells that are gray and copy/paste (or drag) the calculation cells for new inputs
     

    Attached Files:

    Choctaw and C. Stockwell like this.
  5. C. Stockwell

    C. Stockwell

    Joined:
    Dec 12, 2018
    Messages:
    1,221
    Likes Received:
    1,009
    Location:
    RI
    Perfect, exactly what I'm looking for, thanks!
     
  6. EMTDAD

    EMTDAD

    Joined:
    Mar 29, 2013
    Messages:
    1,678
    Likes Received:
    540
    Location:
    North Attleboro, MA
    Choctaw likes this.
  7. MisterHappy

    MisterHappy NES Member

    Joined:
    Jul 28, 2009
    Messages:
    19,801
    Likes Received:
    4,457
    Location:
    On the 16 yard line, shootin' for the Lewis!
    Make up the numbers. After you graduate, you have the skillz you need to work in the jail where Epsteim died, or to become a Statie.
     

Share This Page