Excel Calculation Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ACangemi - 21 Apr 2004 15:54 GMT

This may be easy...

I am adding hours by day (m-f) & totaling at the end of the wor
week... My total includes just the days (EX: =SUM(E6:K6)) But, here i
my question, I want to add to the same cell in adition to standar
hours, Overtime hours that are not calcuated in the Sum, but show i
each individual cell?

Can this be done

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Arvi Laanemets - 21 Apr 2004 17:39 GMT

Hi

Add into some range, p.e. E4:K4, standard hours for every day.

Total hours without overtime are calculated with array formula (enter with
Ctrl+Alt+Enter):
=SUM(IF($E6:$K6<$E$4:$K4,$E6:$K6,$E$4:$K$4))

Total overtime hours (array formula):
=SUM(IF($E6:$K6<=$E$4:$K4,0,$E6:$K6))-SUM(IF($E6:$K6<=$E$4:$K4,0,$E$4:$K4))

--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)

> This may be easy...
>
[quoted text clipped - 8 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message