Help for formula with time

[sherintan]

Hi everyone, i need help for formula in time formulation in excel.

[TABLE="width: 500"]
<tbody>[TR]
[TD]
[/TD]
[TD][TABLE="width: 350"]
<colgroup><col span="2"><col><col></colgroup><tbody>[TR]
[TD]START DEPOSITING[/TD]
[TD]STOP DEPOSITING[/TD]
[TD]Head Count[/TD]
[TD]Manhour (hrs)[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]08:35[/TD]
[TD]21:22[/TD]
[TD]2[/TD]
[TD]12:47[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

The manhour for this machine time is 12.47. However when I multiply with headcount, it will reflect as 4.12hrs which is not right.
Please assist me with the correct formula as I will need to see the total manhour.

Current formula used is =IF(start>stop,1+stop,stop)-start*headcount

 

[FDibbins]

your () are in the wrong place...
=(IF(start>stop,1+stop,stop)-start)*headcount

in fact, try this instead...
=MOD(start-stop,1)*headcount

 

[sherintan]

your () are in the wrong place...
=(IF(start>stop,1+stop,stop)-start)*headcount

in fact, try this instead...
=MOD(start-stop,1)*headcount

Thank you for the answer. However if 1 headcount is 12.47, 2 should be 25.34. However if i will to use your formula the answer is 22.26 instead.
Did i miss out anything?

 

[FDibbins]

I had the times swapped around, apologies...
=MOD(stop-start,1)*headcount

You may need to format as Custom [h]:mm;@