# Time sheet problems

1. ## Time sheet problems

Hi, I'd be extremely grateful if someone would help me with my time sheet. I am doing what's called a Broken Shift; generally, 4 hours on, 4 hours off, then 4 hours on. The payment for each day is based on the SPREAD of hours which can be 12 or sometimes less. The rate of pay is calculated as follows. After SPREAD of 9.5 hrs the following:Between 9.5 and 10.5 hrs = time & half. After 10.5 hrs = double time.

I've attached my spreadsheet which shows the days worked with times and spread.

Grateful for any assistance.

Best regards

Charles

2. ## Re: Time sheet problems

If I'm understanding the breakdown correctly, then I think the following formula will do. Place it in C22 (it's in C23 in the attachment) and fill right:

=\$C\$10*(MIN(C19*24,9.5)+1.5*MAX(MIN(C19*24,10.5)-9.5,0)+2*MAX(C19*24-10.5,0))

Take a look at the attachment to see if it's working as desired. As designed, it does not account for travel time/pay:

3. ## Re: Time sheet problems

Many many thanks CAntosh for your assistance in this. PERFECT working on your part.

Thank you so much

Best regards

Charles

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1