+ Reply to Thread
Results 1 to 3 of 3

Time sheet problems

  1. #1
    Registered User
    Join Date
    06-11-2018
    Location
    Sydney, Australia
    MS-Off Ver
    2016
    Posts
    11

    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
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    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:
    If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

    If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
    https://www.excelforum.com/the-water...ke-thread.html

  3. #3
    Registered User
    Join Date
    06-11-2018
    Location
    Sydney, Australia
    MS-Off Ver
    2016
    Posts
    11

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Time sheet problems
    By CharlesKnigh in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-12-2018, 03:50 AM
  2. Replies: 2
    Last Post: 07-22-2014, 09:20 AM
  3. Having problems with formatting time in a time sheet
    By cptrosakelly in forum Excel General
    Replies: 4
    Last Post: 01-07-2014, 06:12 PM
  4. Replies: 0
    Last Post: 09-15-2012, 06:51 AM
  5. Problems creating a time macro that moves data from one sheet to another.
    By Sanorah in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2012, 08:27 AM
  6. Time sheet Problems
    By jeff dorlaque in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2012, 04:04 PM
  7. Am trying to make a time sheet and having problems with a formula.
    By godnight in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2005, 10:06 AM

Bookmarks

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