Hello,

I am looking for a solution to a puzzling situation I have come across. I am entering data into the takeoff for my materials, and am getting exact numbers for my labor man hours based on the coinciding labor amounts. However, I wish to round these labor man hours to the higher multiple of twelve. For example, I have 58.5 man hours for a particular takeoff, but I want that 58.5 to read as an even 60. Now I have tried to alter the numbers manually, but they are fixed numbers and do not change. I also tried adding a new notes column, renaming it, and manually entering the appropriate numbers, but the total number of project hours is still reflective of the exact numbers on the estimate totals page and not of the new column. I would like to know if there is a formula to make those labor hours round to the multiple of twelve without affecting the takeoff or labor amount numbers, or if there is a way to correlate a new column to the total project hours in place of the original correlation to the labor man hours. If anyone has any ideas it would be greatly appreciated.

Thanks,

Ozzie