+ Reply to Thread
Results 1 to 5 of 5

Need help on OT calculation basing on Concept

  1. #1
    Registered User
    Join Date
    12-12-2018
    Location
    India
    MS-Off Ver
    7
    Posts
    10

    Exclamation Need help on OT calculation basing on Concept

    I need help on Calculating the OT hours basing on below Concept.

    OT Concept is:

    in Weekdays whatever the hours we done in that 1st hour will goes into 1X Payments and remaining hours will be count under 2X Payments.
    in Weekdays there will buffer hours of 0.20mins
    1st hour 1x Payment Calculation in Weekday is= Weekday 1st hour-buffer hours(E.g 1-0.20=0.80)

    And in Weekends(Saturday & Sunday) there is no buffer hours and whenever the SUM Actual hrs in Weekdays is greater then 8, then automatically whatever the hours done in Weekends will comes to 2X Payments.
    if not Weekend 1X calculation will be 8-Sum of Weekdays Actual hrs and remaining hrs will come under 2X payments.

    i have created the sheet basing on the concept

    Could anyone help me with formula for Automatic calculating of 1x and 2X payments through formula for Weekdays and Weekends basing on the above concept
    here i need formula basing on the week names irrespective date for the whole month.

    Attached the Sheet format i have created .
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-12-2018
    Location
    India
    MS-Off Ver
    7
    Posts
    10

    Re: Need help on OT calculation basing on Concept

    Can anyone help me on this at earliest

  3. #3
    Registered User
    Join Date
    12-12-2018
    Location
    India
    MS-Off Ver
    7
    Posts
    10

    Re: Need help on OT calculation basing on Concept

    Can anyone please suggest me on this at earliest
    Last edited by AliGW; 01-09-2019 at 02:22 AM.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,330

    Re: Need help on OT calculation basing on Concept

    Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

    Please bump threads no more than once a day - displays of impatience can lead to no help being offered, so do not ignore this request. Thanks.
    Last edited by AliGW; 01-09-2019 at 02:25 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Need help on OT calculation basing on Concept

    Give some examples with explanation showing how you calculate manually. Upload file.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

+ 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. Split Worksheet Concept
    By stuartgb100 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-12-2015, 05:02 AM
  2. [SOLVED] Concept for a database is it feasible?
    By 33CDonnelly in forum Access Tables & Databases
    Replies: 1
    Last Post: 09-26-2013, 07:09 PM
  3. [SOLVED] Seeking knowledge on an unknown VBA concept
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-21-2013, 07:02 AM
  4. How can I implement this flexible If/And concept?
    By rrbest in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2010, 04:41 AM
  5. Help in Grasping a Concept
    By StompS in forum Excel General
    Replies: 2
    Last Post: 01-17-2006, 05:15 PM
  6. [SOLVED] Help with basic concept
    By DTTODGG in forum Excel General
    Replies: 0
    Last Post: 12-08-2005, 12:40 PM
  7. [SOLVED] Bubble Concept, Bars Instead
    By OLLIE in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-22-2005, 03:06 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