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
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 "
I have something that might help. Send me an email and i'll send it back
Posted by: TAMI AIKMAN | September 29, 2006 at 12:42 PM
I have an Excel Spreadsheet that might help. Send me an email and I can send you the document.
Posted by: Glenda Hewalo | September 29, 2006 at 12:48 PM
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.
Posted by: Susie Ross | September 29, 2006 at 12:53 PM
I have a timesheet in Excel I can share. Send me an email and I would be happy to pass it on to you.
Posted by: Cindy Herr | September 29, 2006 at 01:09 PM
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)
Posted by: Bernie | September 29, 2006 at 01:25 PM
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
Posted by: | September 29, 2006 at 01:40 PM
Would you mind forwarding them to me?
Posted by: Mj | October 02, 2006 at 08:52 AM
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!!
Posted by: Debi Hochstetler | October 02, 2006 at 12:11 PM
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
Posted by: Bernie | October 03, 2006 at 12:41 PM
I'm trying to set up that very thing, if anyone could email ideas that would be great.
Rochelle
Posted by: Rochelle | October 03, 2006 at 05:26 PM
I would be interested in receiving this information. Thanks for your help.
Posted by: Joyce | October 05, 2006 at 02:24 PM
I would love to receive those spreadsheets as well. Thanks! Jill (jritz@vanbeekglobal.com)
Posted by: Jill | October 05, 2006 at 04:37 PM
I would be very interested in the receiving the speadsheets. Thank you
Posted by: Estella Bethea | October 05, 2006 at 09:45 PM
I have a need for this as well and would appreciate anyone sending me their spreadsheet examples. My email is Karen_Brown@lcca.com.
Posted by: Karen | October 06, 2006 at 11:47 AM
Please forward me those email has well... I will be ever so greatful. Thanks!
Posted by: C.Williams | October 09, 2006 at 08:19 AM
I too am very interested in receiving the spreadsheets. Thanks so much.
Posted by: Mary Morrow | October 09, 2006 at 12:03 PM
I'm jumping on the band wagon, can you please send me the spreadsheets too.
Posted by: Becky | October 13, 2006 at 12:01 PM
I would interested in these spreadsheets as well.
Posted by: Charlene | October 23, 2006 at 09:11 AM
I would also love to have one of these spreadsheets as currently the one I use is very complicated!
Posted by: Liz | October 26, 2006 at 11:53 AM
Me, too! Thank you!
Posted by: Celeste | October 26, 2006 at 12:03 PM
is it to late to have one sent to me?
Posted by: Fran | November 03, 2006 at 03:05 PM
I would absolutely love a copy too?
Posted by: Suzanne Quy | November 10, 2006 at 07:10 PM