Do you have a time-keeping spreadsheet? — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

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.

I had this very thing come up about a month ago. I found some great Excel templates on Microsoft's website after doing a Google search on line.

I have a timesheet in Excel I can share. Send me an email and I would be happy to pass it on to you.

I believe I have something very close to what you need. It fills in the days and dates automatically, as well. Send me an email and I will send it to you (on Tuesday)

I would be interested in received these forms as well. Is there a way to get them all at once??

Thanks in advance, Gwen

gwenhall@w-and-k.com

Would you mind forwarding them to me?

Please send them to me as well. We were just talking about making time sheets easier and this may help out!

hochstetler@connellco.com

Thanks!!

Some of the above postings do not have any email links for sending the spreadsheets. Joey, do you want them? I need your email.

Willing to help,
- Bernie

I'm trying to set up that very thing, if anyone could email ideas that would be great.

Rochelle

I would be interested in receiving this information. Thanks for your help.

I would love to receive those spreadsheets as well. Thanks! Jill (jritz@vanbeekglobal.com)

I would be very interested in the receiving the speadsheets. Thank you

I have a need for this as well and would appreciate anyone sending me their spreadsheet examples. My email is Karen_Brown@lcca.com.

Please forward me those email has well... I will be ever so greatful. Thanks!

I too am very interested in receiving the spreadsheets. Thanks so much.

I'm jumping on the band wagon, can you please send me the spreadsheets too.

I would interested in these spreadsheets as well.

I would also love to have one of these spreadsheets as currently the one I use is very complicated!

Me, too! Thank you!

is it to late to have one sent to me?

I would absolutely love a copy too?

{ 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