Timesheet: This extremely easy and simple to use Excel Timesheet will keep track of your employees hours. It allows you to specify and set unpaid breaks in 5 minute intervals on a daily basis.
It allows you to specify and set unpaid breaks in 5 minute intervals on a daily basis. If your employees work hours that span into a new day, no problem, the time calculations will accommodate this. All Start and End times span a 24 hours period in 15 minute intervals, all you do is select a Start time and End time from a drop down list (6 min increments). This makes it impossible to enter times that Excel wont recognize.
The Timesheet will show you both Grand Total Hours and Total hours in 2 formats, decimal (e.g. 15.75) and excel 24 hour time format (e.g. 15:45)
All you do is enter your employee names once, save as a Template (.xlt) (File>Save as) and you are set.
The Time Sheet incorporates a 7 day week with any day being optional. If you need another, or longer period see Excel Timesheet Advanced
In above example, both John and Jane started work at 6:00AM on Monday. Their total hours are currently at 11 and 10 respectively (note the 1 hour lunch time deducted).
Copy Times from Timesheet
This allows you to select any Employee Name and then click Copy Times, the entire weeks worth of that employees times will be copied.
Paste Times from Timesheet
After using the Copy Times (as described above) you would simply select another Employee Name and click Paste Times. This will then paste the times, for the week, to that specific employee. You can leave 'as is' or just change times that need changing.
Excel Timesheet $19.95. Excel 97 through to 2003 Payment Problems/Options 30 Day Money Back Guarantee and HUGE Discounts for Unlimited License.