schedule problem:manhours

Hi all

I just have what is probably a simple problem working with times to find daily manhours.

\1

How do I go about calculating the total manhours field?

Any help appreciated. Thanks in advance

You can use this formula

=SUM(IF(ISNUMBER(C3:C6),MOD(D3:D6-C3:C6,1)))

format result cell as [h]:mm to give a result of 21:00

If you want the result in decimal form ,e.g. 21 or 21.5 then multiply by 24, i.e.

=SUM(IF(ISNUMBER(C3:C6),MOD(D3:D6-C3:C6,1)))*24

These are array formulas which need to be confirmed with CTRL+SHIFT+ENTER. To do this, select cell with formula, press F2, hold down CTRL and SHIFT keys and press ENTER so that curly braces like { and } appear around the formula in the formula bar.

Thank you. Exactly what I was looking for.