I have a spreadsheet for calculating total hours worked, and am using a combined text/formula formula to create the following result:
4.506 / 72
But I want to limit my formula result to 2 decimal places. I have seen examples on how to format the output as hh:mm and as %, but not just 2 decimal places.
My formula is:
="Total Hrs "
&(SUM(J2:J100,"0.00"))&" / "&((COUNTIF(L2:L100,1))*8)
and I thought the "0.00" would set the output format, but it doesn't have any effect.
What am I missing?