IF, THEN Formula?

[Adas]

I'm kinda stuck.



I have created a chart where I have hours posted for each employee per day. I have created another chart where it calculates total amount of hours worked each day for the whole week. What I'm trying to do next is:

If the total hours for the day = to 8.5 somehow I need to subtract .5(lunch) from that total before I total all the days worked for that given week.

Any ideas?

 

[Comfy]

Can you mock up the two tables that you are using for your charts?

 

[Adas]

I have hound a solution.

I have created another chart and pluged in a formula function under "Insert" and selected function/IF. I just wish that there would be an easier way to do the whole chart that to type it this formula to all 210 cells.

 

[CWatts]

When you say "chart" are you meaning "table"? When I (and I think most others) hear "chart" we think of a graphical representation of data.

If that is the case, then you can use the following formula:

=SUM(E7:H7)-COUNTIF(E7:H7,">="&8.5)*0.5

If i'm way off, then disregard.