Formula to Calculate Hours Worked in Excel & DAX: Day or Night Shift! Excel Magic Trick 1826

Download Excel File: https://excelisfun.net/files/EMT1826-...
Learn how to take time values and calculate hours worked for day or night shift with Excel formulas or DAX Formulas. Lean about the famous MOD function to make this calculation easy. Learn how the MOD function algorithm works.
Topics:
1. (00:00) Introduction
2. (00:28) Time as proportion of 24 hours.
3. (01:20) Calculate hours work when there is no nightshift.
4. (01:48) Formula #1: Logical Formula. Calculate hours work when there are some who work past midnight, or the nightshift.
5. (03:32) Formula #2: MOD Function. Calculate hours work when there are some who work past midnight, or the nightshift.
6. (04:28) MOD function algorithm explained.
7. (06:42) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp

#nightshift #mod #module #time #payroll

• #education
• #excel
• #highline_college
• #mike_girvin
• #excelisfun
• #excel_is_fun
• #excel_fun
• #excel_magic
• #excel_formulas
• #excel_functions
• #formulas_and_functions
• #emt
• #emt_1826
• #microsoft_365_excel
• #excel_365
• #night_shift
• #time_past_midnight
• #calculate_hours_worked_in_excel
• #how_to_calculate_hours_worked_in_excel
• #mod_function
• #how_does_the_mod_function_work_in_excel
• #excel_time_values
• #formula_to_calculate_hours_worked_for_night_shift
• #mod_night_shift_formula
• #mod_function_algorithm