+ Reply to Thread
Results 1 to 2 of 2

Excel Timesheet template

  1. #1
    Asphalt
    Guest

    Excel Timesheet template

    Looking for an Excel template for daily timesheet that calculates hours when
    In & Out times are entered.

  2. #2
    Bobbie
    Guest

    Re: Excel Timesheet template

    Hi,
    Need more details. I tried to find a time sheet last year and ended up
    making my own.

    I needed one for a company that gets paid bi-monthly (paid on the 15th
    for hours worked from the 26th of the prior month to the 10th of the
    current month, and then got paid on the last day of the month for hours
    worked between the 11th and the 25th of the same month).

    30 minute lunch was presumed, so it was automatically removed from
    daily hours...so in other words, if I clocked in at 9:00 AM and out at
    5:30 PM, it would only log 8 hours. Plus I had to be able to calculate
    OT, Hol Sick and Vacation hours.

    The pay periods (as outlined above) caused particular issues for months
    that have different # of days! So I needed one tab for months with 30
    days, another tab for months with 31 days and then I sent out a special
    one for February! Aye, aye, aye!

    You see, there are just SO MANY variables, that you'll probably end up
    making you own like I did. Consider formatting it so that cells that
    require data entry are in a specific color and the calculated fields
    are locked...trust me on the last part!

    I started my search, however, by going to the Microsoft Template page
    and downloaded the basic format...then I went to town creating my
    specific formulas. Here is the MS page, if you want to check it out:

    http://office.microsoft.com/en-us/te...s/default.aspx

    Best of Luck to you
    Bobbie


+ 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