Time sheet

Spencer_333

New Member
Joined
Aug 18, 2011
Messages
1
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
 

Forum statistics

Threads
1,082,644
Messages
5,366,728
Members
400,917
Latest member
BlueBeerR

Some videos you may like

This Week's Hot Topics

Top