• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Do you have a time-keeping spreadsheet?

by on
in Admin Pro Forum

Question: Does anyone have an Excel spreadsheet used for time-keeping purposes? I would like to set up a bi-weekly timesheet in Excel for our employees that will calculate their total daily and weekly hours automatically based upon their arrival and departure times (including lunch in/out). But I can't seem to come up with the correct formula or format.

Our government agency also keeps time in tenths of an hour, with 6 minutes equaling one-tenth of an hour. I'd greatly appreciate any assistance or samples!  -- Joey Faber, Fiscal Assistant II, Columbus, Ohio

To access the entire library of Free Customizable Downloads, you must first register with your email address.

Registration gets you:
  • Free access to 125+ customizable HR Forms
  • Free access to job descriptions, interview questions and hiring checklists for 200 positions.
  • Free access to 18 special reports on HR and management topics.
  • Free weekly email newsletter on HR trends and management
  • Special discounts on our upcoming events
Email Address:

{ 2 comments… read them below or add one }

BMD Editors March 15, 2012 at 4:22 pm

Rachelle, once you’ve opened up Microsoft Excel, type “Days” and “Hours” into the first two boxes in the first row of the spreadsheet. Now you can type the days you work in the “Days” column and the hours you work each day in the “Hours” column. Please let me know if you have any other questions.

Reply

Rachelle March 15, 2012 at 3:13 pm

I would like to set up excel spreed sheet to track my hours for work but cant figure out how to set it up, can someone please help!

Thanks

Reply

Leave a Comment