+ Reply to Thread
Results 1 to 2 of 2

Formula to Count Hours In Different Bracket - Timesheet Calculation

  1. #1
    Registered User
    Join Date
    05-04-2020
    Location
    Nottingham, England
    MS-Off Ver
    2016
    Posts
    4

    Formula to Count Hours In Different Bracket - Timesheet Calculation

    Hi,

    I've spent hours trying to work this out ...

    We have 4 brackets for determining pay rate. 17:00 to 00:00, 00:00 to 06:00, 06:00 to 08:00 and 08:00 to 17:00

    depending on the contract, the day and the type of work depends on the pay rate, so i am looking to just calculate the hours out that fall within each of these ranges based on a start time and end time.

    I get to a point that i think i have cracked it, but then try a time range and it throws it all out!

    Any help would be greatly appreciated! I include the workings i have so far!

    thanks in advance.

    Pete
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,892

    Re: Formula to Count Hours In Different Bracket - Timesheet Calculation

    It may be more helpful to show the values that you want to see rather than the values the formulas are yielding which are assumed to be incorrect.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Timesheet formula to subtract 1/2 a hour lunch only if 6 hours are worked
    By MrsBoot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2020, 01:55 PM
  2. Night Hours Timesheet Calculation
    By EmmaTwks in forum Excel General
    Replies: 4
    Last Post: 07-05-2019, 09:19 AM
  3. adding formula [on timesheet to show overtime hours]
    By toddp2 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-05-2017, 12:47 PM
  4. Replies: 2
    Last Post: 07-18-2014, 03:00 AM
  5. [SOLVED] Timesheet with overtime calculation between certain hours, days only
    By ExcelNoviceHexham in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-02-2013, 12:21 PM
  6. Need formula for calculating hours in timesheet
    By alannanoelle in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-25-2013, 02:02 PM
  7. Timesheet formula for calculating ordinary hours and overtime hours.
    By zoen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-18-2011, 04:23 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