Friday, December 26, 2014

Multiplying hours and dollars

In order to obtain the right results of Dollar X Hours calculations in cell C12, the total hours of cell C10 must be multiplied by 24 to compensate on the way that Excel is handling cells with time format. Thus C12 should have the formula C10*24*C11.



* * *

No comments:

Post a Comment