Excel Forum

Excel Magic Trick 624: Hours Worked Part Day Shift & Part For Night Shift MEDIAN Function for Hurdle

See how to break apart the hours worked into one part for the Day Shift and one part for the night shift using the MEDIAN function instead of the IF function. The MEDAIN function can be used when there are different calculations depending on whether the hurdle has been breached or not. Time Math Calculations. Payroll.

Realted video:
Excel Magic Trick 100: Instead of Long IF, Use MEDAIN function Commission W Hurdle Calculation
Excel Magic Trick 501: Excel Time Format & Calculations (10 Examples)
Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time)

Got a Question? Ask it Here in the Forum.