+ Reply to Thread
Results 1 to 2 of 2

Time and how to calculate three possible rates that span more than one day...

  1. #1
    Registered User
    Join Date
    07-03-2014
    Location
    Toronto, ON
    MS-Off Ver
    2013
    Posts
    1

    Time and how to calculate three possible rates that span more than one day...

    So here's my problem, I've got a timesheet estimate form that I'm putting together and I can't get the time calculation to work correctly.

    The setup is simple:

    I2 = Start Time
    J2 = End Time
    K2 = Total Shift Hours estimated

    Now this is where it gets tricky for me, I need to calculate the hours worked that fall into three possible categories:

    Normal time = between 07:00 and 15:00
    Afternoon premium = between 15:00 and 23:00
    Overnight premium = between 23:00 and 07:00

    In an effort to make it easier for the people doing the data entry I'm trying to avoid them entering more than a single start and single end time for each line of data.

    I've reviewed several examples and have written so many variations of different formulas that I'm going a little cross-eyed at this point and am in serious need of help.

    I've reviewed several examples and have written so many variations of different formulas that I'm going a little crosseyed at this point and am in serious need of help.

    Attached is the sample I'm working with at the moment....

    Timesheet_Test.xlsx

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,160
    Hello judefreeman,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. [SOLVED] Need formula to calculate number of hours in a time span that are between 6PM and 6AM
    By gibson2503 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-05-2014, 06:13 PM
  2. How can I calculate various rates of pay on a time card
    By jpmanfredo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-30-2013, 03:03 PM
  3. Time Span in hours
    By Juncus in forum Excel General
    Replies: 1
    Last Post: 11-08-2008, 10:41 AM
  4. Replies: 5
    Last Post: 06-07-2008, 02:32 PM
  5. [SOLVED] Time Span
    By mrbalaje in forum Excel General
    Replies: 6
    Last Post: 06-16-2005, 07:05 PM

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