Calculation question.

gleemonex69

New Member
Joined
Dec 9, 2010
Messages
37
s!AlbQbFuZKOSXnA4TSI0w0c2ONvGG
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.

s!AlbQbFuZKOSXnA4TSI0w0c2ONvGG

s!AlbQbFuZKOSXnA4TSI0w0c2ONvGG
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Do you just want something like this:

F
16
28
324
410
524
68
71
8
933

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

Worksheet Formulas
CellFormula
F9=SUMIF(F1:F7,"<>24")

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>
 
Upvote 0
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...

Code:
=SUMIFS(D17:S17,D17:S17,"<>24",D16:S16,"HRS")
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,064
Members
448,545
Latest member
kj9

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top