Results 1 to 4 of 4

Repair a function Choose, weekday, if formula.

Threaded View

  1. #1
    Registered User
    Join Date
    05-18-2014
    MS-Off Ver
    Excel 2010
    Posts
    7

    Repair a function Choose, weekday, if formula.

    So I found this formula online. It calculates the Overtime hours on Fridays and Saturdays.
    Formula: copy to clipboard
    =CHOOSE(MAX(WEEKDAY(A2),4)-3,0,IF(C2< B2,C2,0)*24,D2,(IF(C2< B2,1,C2)-B2)*24)


    However it does not work properly. When it is friday it only displays 0.42

    So I want to change it so it only displays OT on saturdays. And I want another one that displays OT on sundays(different pay).

    Can somebody help me with this?

    P.S. any suggestions with the G column?
    Attached Files Attached Files
    Last edited by arisigfusson; 05-21-2014 at 06:39 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Choose and Weekday Function
    By juan.doe in forum Excel General
    Replies: 3
    Last Post: 05-12-2014, 08:27 AM
  2. [SOLVED] Formula help to choose lowest cost from multiple vendors and then choose vendor
    By roland_arv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-27-2013, 07:48 PM
  3. [SOLVED] Using CHOOSE and WEEKDAY to Display Wednesday and Saturday Dates With Time
    By wtierce in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-25-2013, 11:34 AM
  4. Replies: 14
    Last Post: 07-24-2013, 06:08 PM
  5. Intentionally overwrite formula then repair
    By Swift4Play in forum Excel General
    Replies: 2
    Last Post: 11-26-2009, 04:54 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