Calculation question.

[gleemonex69]

Good afternoon, everyone. I'm working on a restaurant schedule worksheet but I'm stuck in one calculation. Everyday, I have a calculation that will display total hours worked. If no hours are worked, it will display "24". At the end of the week, I would like to display total hours worked. But the calculation is adding the "24". I know there is a way to not include the "24", but I can't figure it out. Thank you all in advance.

 

[Eric W]

Do you just want something like this:

	F
1	6
2	8
3	24
4	10
5	24
6	8
7	1
8
9	33

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula F9 =SUMIF(F1:F7,"<>24") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[gleemonex69]

Below is a link to an image on what I'm working on.


https://1drv.ms/i/s!AlbQbFuZKOSXnA4TSI0w0c2ONvGG

 

[gleemonex69]

Below is a link to an image on what I'm working on.


https://1drv.ms/i/s!AlbQbFuZKOSXnA4TSI0w0c2ONvGG

 

[Atroxell]

I worked on it with range A16 to T17, but how about a formula like this?

It excludes the 24 hour values and only sums the others...

=SUMIFS(D17:S17,D17:S17,"<>24",D16:S16,"HRS")

 

[gleemonex69]

That worked for me. Thank you so much.