• 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


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?

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/15224/do-you-have-a-time-keeping-spreadsheet "

{ 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