Looking for an Excel template for daily timesheet that calculates hours when
In & Out times are entered.
Looking for an Excel template for daily timesheet that calculates hours when
In & Out times are entered.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks