private void PolishingUp()
        {
            pictureBox7.Image = Properties.Resources.processing;

            //Deleting the 2 device columns
            xlWorksheet.Columns[5].Delete();
            xlWorksheet.Columns[6].Delete();
            //Frezzing the top row
            xlWorksheet.Application.ActiveWindow.SplitRow = 1;
            xlWorksheet.Application.ActiveWindow.FreezePanes = true;
            //Applying Filter
            Excel.Range firstRow = (Excel.Range)xlWorksheet.Rows[1];
            firstRow.AutoFilter(1,Type.Missing,Excel.XlAutoFilterOperator.xlAnd,Type.Missing, true);
            //Checking if change room time(F) is greater than 15min
            range = xlWorksheet.get_Range("F2", "F" + RC);
            Excel.FormatCondition conditionF = (Excel.FormatCondition)range.FormatConditions.Add(Excel.XlFormatConditionType.xlCellValue, Excel.XlFormatConditionOperator.xlGreater, "=0,0104166666666667", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            conditionF.Interior.Color = 13551615;
            conditionF.Font.Color = -16383844;
            //Checking col(G) for times between 05:30 and 06:30
            range = xlWorksheet.get_Range("G2", "G" + RC);
            Excel.FormatCondition conditionG1 = (Excel.FormatCondition)range.FormatConditions.Add(Excel.XlFormatConditionType.xlCellValue, Excel.XlFormatConditionOperator.xlBetween, "0,229166666666667", "=0,270833333333333", Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            conditionG1.Interior.Color = 13551615;
            conditionG1.Font.Color = -16383844;
            //Checking col(G) for times between 17:30 and 18:30
            Excel.FormatCondition conditionG2 = (Excel.FormatCondition)range.FormatConditions.Add(Excel.XlFormatConditionType.xlCellValue, Excel.XlFormatConditionOperator.xlBetween, "=0,729166666666667", "=0,770833333333333", Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            conditionG2.Interior.Color = 10284031;
            conditionG2.Font.Color = -16751204;
            //Checking Entry col(D) for times between 06:05 and 10:30
            range = xlWorksheet.get_Range("D2", "D" + RC);
            Excel.FormatCondition conditionD1 = (Excel.FormatCondition)range.FormatConditions.Add(Excel.XlFormatConditionType.xlCellValue, Excel.XlFormatConditionOperator.xlBetween, "=0,253472222222222", "=0,4375", Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            conditionD1.Interior.Color = 13551615;
            conditionD1.Font.Color = -16383844;
            //Checking Entry col(D) for times between 18:05 and 22:00
            Excel.FormatCondition conditionD2 = (Excel.FormatCondition)range.FormatConditions.Add(Excel.XlFormatConditionType.xlCellValue, Excel.XlFormatConditionOperator.xlBetween, "=0,753472222222222", "=0,916666666666667", Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            conditionD2.Interior.Color = 10284031;
            conditionD2.Font.Color = -16751204;
            //Checking Exit col(E) for times between 07:00 and 18:00
            range = xlWorksheet.get_Range("E2", "E" + RC);
            Excel.FormatCondition conditionE1 = (Excel.FormatCondition)range.FormatConditions.Add(Excel.XlFormatConditionType.xlCellValue, Excel.XlFormatConditionOperator.xlBetween, "0,291666666666667", "=0,75", Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            conditionE1.Interior.Color = 13561798;
            conditionE1.Font.Color = -16752384;
            //Checking Exit col(E) for times between 04:00 and 16:00
            Excel.FormatCondition conditionE2 = (Excel.FormatCondition)range.FormatConditions.Add(Excel.XlFormatConditionType.xlCellValue, Excel.XlFormatConditionOperator.xlBetween, "0,166666666666667", "=0,25", Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            conditionE2.Interior.Color = 10284031;
            conditionE2.Font.Color = -16751204;
            //Centering Columns F G H
            range = xlWorksheet.get_Range("F2", "H" + RC);
            range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;

            pictureBox7.Image = Properties.Resources.complete;
            SaveFile();
        }