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 at 11:29 AM.

  1. C. Stockwell

    C. Stockwell

    Joined:
    Dec 12, 2018
    Messages:
    1,185
    Likes Received:
    988
    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:
    919
    Likes Received:
    1,330
    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,119
    Likes Received:
    959
    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,263
    Likes Received:
    1,501
    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,185
    Likes Received:
    988
    Location:
    RI
    Perfect, exactly what I'm looking for, thanks!
     
  6. EMTDAD

    EMTDAD

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

    MisterHappy NES Member

    Joined:
    Jul 28, 2009
    Messages:
    19,788
    Likes Received:
    4,439
    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