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


Comments

I have something that might help. Send me an email and i'll send it back

I have an Excel Spreadsheet that might help. Send me an email and I can send you the document.

To read the rest of this article you must first register with your email address.

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