I have been working within HR & Payroll for the Recruitment Industry for over 20 years in Australia and have created my own versions of timesheets, complete with complex formulas. I have never come across a tool which is as easy to use and covers so many variables, especially freely available! I too would love to see a Multiple Employee version, as well as seeing if you were able to overcome the challenge of Shift Workers. Crossing over midnight and being able to incorporate Shift Penalties. I have Liked and Subscribed. I will now be looking at what other Tools & Resources you have released. Thank you so much! 👍
Thanks for your kind words. More HR templates are on the way soon. :) Any help in spreading the word within your HR industry network would be great. Thanks & Best wishes.
I have been working as an accountant for over 15 years in the USA, and have special Excel calculations for the contract laborers with a complex over-time and double time rules. It is so simple how I can verify that my tables do not have a glitch and it took me 15 minutes to get it with your simple and clear tables and explanations. I was looking for something like that for a few years now. Thank you so very much and bravo!
Very glad to hear. I sincerely thank you for taking the time to provide feedback. Please take a look at our new Finance Manager template ruclips.net/video/28fbzqadiv8/видео.html which simplifies accounting tasks. Looking forward to your feedback. Best wishes.
hey tatyana, i feel good when i hear people interested in timecard complex tools. i have a very standard one that creates multiples of timecards by using an interface, no VBA only excel advanced formulas. in my channel there are videos of the multiple craeator tool can make upto 400 timesheets maximum that counts monthly totals or anything between 1-30 days. in the video for the multiple one you can download a sample that creates 2 time cards, i have no video teaching the formulas for that multipurpose one but recently i created another one that makes single timecard and you can download it for free. i know this will be of help to you also. click my account and it will take you to the time cards. if you are interested in the multiple one for use in your company, you can promote my work by buying at a very cheap price and i will be happy. once you view the videos, please dont forget to like n subscribe.
Thank you for this worksheet it's awesome! I do have a question an employee works 12am-1230am But works the same day how do I create another entry for the same day?
You are welcome. Thank you for showing interest in our template and sharing your valuable feedback. If the 12 am to 12:30 am belongs to previous date. I would like to inform you that our premium version of the template supports the night shift. Following is the link to the same: indzara.com/product/timesheets-manager-excel-template/ Or if the 12 to 12:30 am and another entry on the same day belongs to single shift, you will have to enter the start as 12:00 am and end as the second entry end time. The mean time has to be considered as break time. Best wishes.
This is wonderful.Thank you so much for sharing this ...I have a small issue ,my weekend is not being highlighted the data entry column as yellow in office 2007.Can you help
Thank you. The templates are only tested in Excel versions post 2010. Is it only weekends that are not highlighted? Please email file to support@indzara.com with questions. Best wishes.
How can I enter data by daily hours ( regular, over time and holiday) basis instead of entering start and end time. Also can I enter work location or work sites on daily basis?
Thank you for showing interest in our template. Regarding holiday - you need to enter it in the setting under holiday list. For regular and overtime, you need to unhide column F to O in Data Entry sheet and delete the formula in column I, G and H to enter the regular hours and over time directly. Best wishes.
Is there any way we can have a column the sas discription of work and we can select the diferent rates for for different jobs such as for driving rate is different and if he works in shop its a different rate?
Thank you for showing interest in our template. We can customize our premium version of the Timesheet Manager template to setup different rates for each employee. We take customization projects for a fee and following is the link to the premium version of the template: indzara.com/product/timesheets-manager-excel-template/ Please write to support@indzara.com for estimation. Best wishes.
Hello, Please could you help me understand the way the spreadsheet is built? What do I_T2 and I_T3 refer to? Incredible job. As a relative beginner in excel how can I improve and get to your level?? Could you teach me?
Thanks. I don't have a tutorial yet for this. The I_T, I_T3 are named ranges. They are referring to other cells in the workbook. Instead of saying cell A2, a named range (we can name how we want) can be easier to follow when writing complex formulas. If you are a beginner, please see a free course I created: courses.indzara.com/p/useful-excel-for-beginners Best wishes.
Thank you so much for this video and download. As I was browsing around the Template I noticed on the DATA Entry sheet there was a line between row 6 and row 7 which extends the entire worksheet. Is there a way to remove or hide this line from Col P outward? Thanks again, Frank
Hello I have just downloaded this time sheet and it is amazing. the only problem i have had is that i can not save to the existing work sheet and have to make a copy all the time. I have unprotected the sheets and still not able to save without making a copy Please help if you can. Thank You
Thanks for downloading. Glad to hear. Can you please save the file to a folder where you can save as editable copy (instead of a read-only version)? Please send screenshots to support@indzara.com with the issue. I have never come across the issue before. We will look into it. Best wishes.
Hi, if you could please clarify the formula for the date. (I_ST_DT)? and the WREP formula on pay period. Been trying to figure it out and i cant.. thank you
Thank you for showing interest in our template. The regular hours and overtime hours is setup in settings. Hence if an employee works for 10 hours and 8 hours is the regular working hours, then 2 hours is considered as over time as per your settings. You can download the template from the below link and test the same: indzara.com/free-excel-template-for-time-card-work-hours-calculator/ Best wishes.
![Create a TIMESHEET Template using an Excel Spreadsheet - [ 15 Minute Tutorial ]](/img/1.gif)
I have been working within HR & Payroll for the Recruitment Industry for over 20 years in Australia and have created my own versions of timesheets, complete with complex formulas.
I have never come across a tool which is as easy to use and covers so many variables, especially freely available!
I too would love to see a Multiple Employee version, as well as seeing if you were able to overcome the challenge of Shift Workers. Crossing over midnight and being able to incorporate Shift Penalties.
I have Liked and Subscribed. I will now be looking at what other Tools & Resources you have released.
Thank you so much! 👍
Thanks for your kind words.
More HR templates are on the way soon. :)
Any help in spreading the word within your HR industry network would be great.
Thanks & Best wishes.
I have been working as an accountant for over 15 years in the USA, and have special Excel calculations for the contract laborers with a complex over-time and double time rules. It is so simple how I can verify that my tables do not have a glitch and it took me 15 minutes to get it with your simple and clear tables and explanations. I was looking for something like that for a few years now. Thank you so very much and bravo!
Very glad to hear. I sincerely thank you for taking the time to provide feedback.
Please take a look at our new Finance Manager template ruclips.net/video/28fbzqadiv8/видео.html which simplifies accounting tasks. Looking forward to your feedback.
Best wishes.
hey tatyana, i feel good when i hear people interested in timecard complex tools. i have a very standard one that creates multiples of timecards by using an interface, no VBA only excel advanced formulas. in my channel there are videos of the multiple craeator tool can make upto 400 timesheets maximum that counts monthly totals or anything between 1-30 days. in the video for the multiple one you can download a sample that creates 2 time cards, i have no video teaching the formulas for that multipurpose one but recently i created another one that makes single timecard and you can download it for free. i know this will be of help to you also. click my account and it will take you to the time cards. if you are interested in the multiple one for use in your company, you can promote my work by buying at a very cheap price and i will be happy. once you view the videos, please dont forget to like n subscribe.
at first glance, your XL sheet designs layout and color formatting already superb!! thanks for sharing :)
Thank you so much 🙏
This is brilliantly done!! 👍👍
Thank you for sharing your valuable feedback.
Best wishes.
Thank you for this worksheet it's awesome! I do have a question an employee works 12am-1230am
But works the same day how do I create another entry for the same day?
You are welcome. Thank you for showing interest in our template and sharing your valuable feedback.
If the 12 am to 12:30 am belongs to previous date. I would like to inform you that our premium version of the template supports the night shift. Following is the link to the same:
indzara.com/product/timesheets-manager-excel-template/
Or if the 12 to 12:30 am and another entry on the same day belongs to single shift, you will have to enter the start as 12:00 am and end as the second entry end time. The mean time has to be considered as break time.
Best wishes.
This is wonderful.Thank you so much for sharing this ...I have a small issue ,my weekend is not being highlighted the data entry column as yellow in office 2007.Can you help
Thank you. The templates are only tested in Excel versions post 2010. Is it only weekends that are not highlighted?
Please email file to support@indzara.com with questions.
Best wishes.
How can I enter data by daily hours ( regular, over time and holiday) basis instead of entering start and end time. Also can I enter work location or work sites on daily basis?
Thank you for showing interest in our template.
Regarding holiday - you need to enter it in the setting under holiday list.
For regular and overtime, you need to unhide column F to O in Data Entry sheet and delete the formula in column I, G and H to enter the regular hours and over time directly.
Best wishes.
such a great timesheet, very ez to use. Thanks alot. Like and Sub. Keep on the great works
Thanks for feedback and subscribing.
Best wishes.
Is there any way we can have a column the sas discription of work and we can select the diferent rates for for different jobs such as for driving rate is different and if he works in shop its a different rate?
Thank you for showing interest in our template.
We can customize our premium version of the Timesheet Manager template to setup different rates for each employee. We take customization projects for a fee and following is the link to the premium version of the template:
indzara.com/product/timesheets-manager-excel-template/
Please write to support@indzara.com for estimation.
Best wishes.
Good explination . thank you
Thank you.
Best wishes.
Hello, Please could you help me understand the way the spreadsheet is built? What do I_T2 and I_T3 refer to? Incredible job. As a relative beginner in excel how can I improve and get to your level?? Could you teach me?
Thanks.
I don't have a tutorial yet for this. The I_T, I_T3 are named ranges. They are referring to other cells in the workbook. Instead of saying cell A2, a named range (we can name how we want) can be easier to follow when writing complex formulas.
If you are a beginner, please see a free course I created: courses.indzara.com/p/useful-excel-for-beginners
Best wishes.
Thank you so much for this video and download. As I was browsing around the Template I noticed on the DATA Entry sheet there was a line between row 6 and row 7 which extends the entire worksheet. Is there a way to remove or hide this line from Col P outward? Thanks again, Frank
You are welcome.
Please try unfreezing the panes.
View menu --> Window panel --> Freeze Panes --> Unfreeze Panes
Best wishes.
Thank you
You are welcome.
Best wishes.
Hello
I have just downloaded this time sheet and it is amazing. the only problem i have had is that i can not save to the existing work sheet and have to make a copy all the time. I have unprotected the sheets and still not able to save without making a copy Please help if you can.
Thank You
Thanks for downloading. Glad to hear.
Can you please save the file to a folder where you can save as editable copy (instead of a read-only version)? Please send screenshots to support@indzara.com with the issue. I have never come across the issue before.
We will look into it.
Best wishes.
Hi, if you could please clarify the formula for the date. (I_ST_DT)? and the WREP formula on pay period. Been trying to figure it out and i cant.. thank you
Can you please send your questions with a reference of the templates name to support@indzara.com? We will get back within one working day. Thank you!
Sir can not be prepare for multiple employees detail in one sheet?
The current version supports only one employee. Sorry.
I need to build one for multiple employees in future.
Best wishes.
@@indzara waiting for it . thank you so much
What to do for multiple employees??? Please help
Something I need to work on. Sorry, I don't have it yet. Currently each employee has to be in a separate file.
Best wishes.
i have one that does that but am selling. check this link .drive.google.com/file/d/1ZK3t...
and my email is ptakim.pk@gmail.com
where to put start and end time of overtime hours???
Thank you for showing interest in our template.
The regular hours and overtime hours is setup in settings. Hence if an employee works for 10 hours and 8 hours is the regular working hours, then 2 hours is considered as over time as per your settings.
You can download the template from the below link and test the same:
indzara.com/free-excel-template-for-time-card-work-hours-calculator/
Best wishes.
GOOD MORNING SIR
DOWNLOAD LINK NOT AVAILABLE
PLEASE EXPLAIN HOW TO DOWNLOAD SHEET
Please see this page indzara.com/2018/09/timesheet-template-excel/ for download link.
Best wishes.
HOW CAN I FIX IF I WORK 19:00 PM TO 00:00 AM
Thanks for using the template. Can you please explain the specific issue? If you enter those times, do you see any errors?
Best wishes
Subscribed ♥️
IG: iamnepthalie
Thank you.
Best wishes.