I'm attaching a workbook that has a module (Format_Calc_Sheet) used for the initial formatting of the data. The Formatting code does work, for this first step. The code within the workbook, just provides a frame of reference of how the "look and feel" of the worksheet was generated. It initially is downloaded from a third party, and not VBA friendly,
Toward the end of the code is where I would like some assistance. As can be seen, Column H: just displays Hours and Minutes
, but there is more within the cell that just "[h]:mm"
However, what is needed, is the correct VBA syntax, to subtract the "[h]:mm" in column H:
, from a fixed value (30 minutes), and if the value in the column is greater than 30 minutes, then that row is highlighted.