Excel Calculation Question

  • Thread starter Thread starter ACangemi
  • Start date Start date
A

ACangemi

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
 
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))
 
Back
Top