Timesheet calculator

Hi Guys,

I am trying to build an Excel timesheet cal. with Award overtime rules. But it is not quite working when the weekly hours over 38 hours.

The situation is:

Normal Time: 38 hours per week (7am - 7 pm Mon-Fri) or 8 hrs per day
Overtime (1.5): first 2 hours (weekly/daily)
Overtime (2): after 10 hours per day and all hours work on Sunday

Other: Saturday - from 7am to 12.30 pm paid at normal time (if the normal time hours worked druing Mon-Fri do not exceed 38 hours). After 12.30pm will pay overtime (1.5)

I can work on daily hours with overtime rules easily, but when the normal hours (weekly) exceed 38 hours during the week, it will be very complicated and I have tried many ways but it will say circular reference warning...

Hope someone can help?

Thanks

Originally Posted by oldchippy

Hi,

Welcome to the forum, no need to invent the wheel again

http://spreadsheetpage.com/index.php...ee_time_sheet/

Hi, Thanks
I have looked at the timesheet, one thing I would like to ask, how did you do it (when protect sheet, hide formula but still can allow ppl to enter data?)

Thanks