MOD Function
Detailed Process Flow to Use the MOD Function in Excel
What is the MOD Function?
The MOD function in Excel returns the remainder after dividing one number by another. It is mainly used to separate integer and decimal values, cycle through repeating sequences, or perform time-related calculations.
Purpose of Using the MOD Function
- To extract the decimal part of a number.
- To handle time calculations, such as converting decimal hours into standard time format (HH:MM).
- To cycle through periodic sequences, like assigning shifts or processing recurring patterns.
Benefits of the MOD Function
✅ Extracts Decimal or Remainder Values – Helps in breaking down numbers into useful parts.
✅ Simplifies Time Calculations – Converts decimal hours into minutes easily.
✅ Helps in Repeating Patterns – Useful in cyclic processes like scheduling.
✅ Enhances Formatting of Time Data – Useful for making work hours more readable.
Syntax of the MOD Function =MOD(number, divisor)
- number → The number you want to divide.
- divisor → The number by which you divide.
Example: Applying MOD Function to Convert Decimal Hours into HH:MM Format
| Act. Hrs. | MOD Formula | Mod (HH:MM) Output |
|---|---|---|
| 8.30 | =MOD(F2,1)*60 | 8:30 |
| 9.16 | =MOD(F3,1)*60 | 9:16 |
| 8.44 | =MOD(F4,1)*60 | 8:44 |
| 8.32 | =MOD(F5,1)*60 | 8:32 |
| 8.41 | =MOD(F6,1)*60 | 8:41 |
| 8.36 | =MOD(F7,1)*60 | 8:36 |
| 8.34 | =MOD(F8,1)*60 | 8:34 |
| 8.25 | =MOD(F9,1)*60 | 8:25 |
| 8.17 | =MOD(F10,1)*60 | 8:17 |
| 8.34 | =MOD(F11,1)*60 | 8:34 |
How to Apply MOD Function in Excel (Step-by-Step)
1️⃣ Select the Cell – Click on the first cell under the "Mod" column where you want the converted value.
2️⃣ Enter the Formula – Type =MOD(F2,1)*60 (assuming F2 contains the "Act. Hrs." value).
3️⃣ Press Enter – This extracts the decimal part of the hours and converts it into minutes.
4️⃣ Change Format – Format the result as [HH]:MM for correct time display.
5️⃣ Drag Down – Use the fill handle (bottom-right corner of the cell) to apply the formula to the entire column.
Final Output After Applying MOD
| Act. Hrs. | Mod (HH:MM) Output |
|---|---|
| 8.30 | 8:30 |
| 9.16 | 9:16 |
| 8.44 | 8:44 |
| 8.32 | 8:32 |
| 8.41 | 8:41 |
| 8.36 | 8:36 |
| 8.34 | 8:34 |
| 8.25 | 8:25 |
| 8.17 | 8:17 |
| 8.34 | 8:34 |
Conclusion
The MOD function in Excel is a powerful tool for handling decimal hours, repeating sequences, and remainder calculations. It is especially useful for time-related formatting, payroll calculations, and scheduling processes. 🚀