Man hours calculation
Hi,
Here is another answer depending on what you are really asking:
If you have a column of times (entries of the form 7:00), say C2:C33 and you
want to get the total
=sum(c2:C33) and then formatting the cell to [h]:mm:ss format.
Or maybe you want to use =SUMIF(A2:A33,"Man Hours",C2:C33)
and to get Woman hours
=SUMIF(A2:A33,"Woman Hours",C2:C33)
You can see that you got 3 or 4 completely different answers, because you
question is not complete.
--
Thanks,
Shane Devenshire
"Mama Mia" wrote:
How do I calculate man hours for a month?
|