gerard_gonzales33
Registered User

Hi Arlu;

Actually some of the queries are left unanswered. But it's ok. It can be considered as solved. Thank you.

Is this solved - http://www.excelforum.com/excel-work...ple-cells.html

Hi!. am new here and am having trouble in establishing my time sheet. Here are the details of my time sheet:
1. Fix working schedule: Mondays to Fridays; 8:30am to 5:30pm with an unpaid lunch break.
2. Overtime starts at 6:00PM with a minimum OT of 1hr (below 1hr is not considered as OT.
3. cut-off dates is every 11th - 25th of the month and 26th - 10th of the next month.
4. Semi-monthly basis.

I hope that someone could help me. Am not good at excel:<

Thank you so much!