Time sheet

[Spencer_333]

Hi All,

I have need to create a time sheet on excel but I'm experiencing some problems. What i need the sheet to do is below:-

1. Have start time / finish time x 2 for each day.
2. Automatically work out hours worked.
3. Should there be less than a 6 hour break between finish time and start time the employee will get paid the whole way through. I.e. if they finish 2300 on Monday then start 0400 on Tuesday they get paid right through.
4. Any thing over 60 per week is over time.
5. Any weekend working is overtime.
6. Weekend work is charged in 4 hour blocks, i.e. if they work from 0100 - 0200 they get paid 4 hours, or 0100 - 0500 they get 8 hours @ over time.

The sheet doesn't need to have any rates of pay.

Any help is much appreciated!!!

Cheers,

Spence

 

[Robert Mika]

Hi spencer and welcome to the board.

You may start from here:

http://office.microsoft.com/en-gb/templates/CT010117277.aspx

and then if you have any problem post it here.