Excel Forum
Similar Content
Formula to Count Occurrences of a Word in a Cell or Range in Excel
Tutorial: Formula to count how many times a word appears in a single cell or an entire range in Exce...
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...
Get the Last Day of the Month in Excel
Tutorial: How to get the last day of the month, including the date and day of week, for any date in ...



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.