Adding hours
Here's a simplified version of your formula. First, ditch the supurfluous +
signs,
=IF((B3-B2)*24<0,-(B3-B2)*24,(B3-B2)*24)+IF((B5-B4)*24<0,-(B5-B4)*24,(B5-B4)*24)
Second, the Abs function simplifies this significantly:
=Abs(b3-b2)*24+Abs(b5-b4)*24
My guess as to the answer to your question is:
=abs(sum(b3:g3)-sum(b2:g2))*24+abs(sum(b5:g5)-sum(b5:g5))*24
Regards,
Fred
"Yitzhack" wrote in message
...
All,
I'm trying to add hours per week B2:G2 but i cannot make it work please
help. I have this formula to add the hours daily. the formula needs to
return
hours worked in the same format
=+IF(+(B3-B2)*24<0,-(B3-B2)*24,+(B3-B2)*24)+IF(+(B5-B4)*24<0,-(B5-B4)*24,+(B5-B4)*24)
--
Regards
YM
|