This simple formula is the building block for the rest of the tutorial and works for day and night shifts alike. *24 is what changes the time format into a decimal format that is easier to read and can be used in mathematical calculations, such as for wages. Time_Out is when they stopped work for whatever reason. Notes Magic Formula to Calculate Hours Worked =MOD(Time_Out - Time_In,1)*24
Night Shift Hours Worked with Breaks and Lunch (Some times in this tutorial are presented using the 24 hour clock, or military time, but that doesn't change anything in regard to the formulas or their outcomes.) Sections:ĭay Shift Hours Worked with Breaks and Lunch This tutorial will show you the simple formula that you can use for this and tell you how you can customize it to work for your situation, where you might have more breaks or fewer breaks for which to account. Single simple formula to calculate the hours worked for a day shift or night shift and including lunch and all breaks in the calculation.
