I created a template of semi-monthly time sheet including overtime. I tried to make it automated (self calculating) using excel, but I lock of information in creating excel formulas. The things that I need to know are as follows:
1. How can I automatically input the dates or is there a formula in entering the dates that will recognize the week ends? (i.e. Saturdays and Sundays)
2. Formula for tardiness and under time (work schedule is 8:30 AM to 5:30 PM Mondays to Fridays).
3. Over time has a minimum of 1hr claim which starts at 6:00 PM.
4. In entering the time, can I use the hh:mm without affecting the formulas that will be established? ( 'coz every time I enter a time it always includes the seconds)
Am attaching my template as reference. ( I hid some of the columns for this is manually to be type).
Thanks
Gerard "the desperate timekeeper"
Bookmarks