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

Try this

=24*(abs(B3-B2)+abs(B5-B4))

"Yitzhack" wrote:

> 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
>

See my reply in excel.misc NG. Please don't multipost to different groups.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


"Yitzhack" <(E-Mail Removed)> wrote in message
news:9106B98F-B9F7-4387-8DFA-(E-Mail Removed)...
> 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
>
>