Excel formula/function correct, but not working.

Question

As you can see, when I open the dialog box for my formula it says the formula result should be 7.64. But once I press the "OK" button it instead shows the result of "0". Not sure why it is not working. My formulas are calculating automatically and I have actually switched it to manual then put it back to automatic. I have pressed the "Calculate Now" & "Calculate Sheet" button and both did not change anything, the result was still 0. I have actually deleted the formula then hand typed it back in again but it is still not working. I need this formula to work, I use this for payroll. It's so much easier if this formula would actually work instead of me doing a regular "=average" formula because I do not want to add the weekend zero hours into the formula.

Any suggestions for what to do? Thanks in advance!

Update, I found more formulas that are not being calculated even though I did the same as above. It's not calculating a simple formula "=sum(C6:R6)" I think it might be glitch/bug inside my worksheet. I guess I'm going to have to re-type my whole worksheet over again. I'll update if the problem stays.

Answer 1

Did you try the copy>paste special?

Gord

Answer 2

I tried sending an email but it will not show my the email address because I do not have an Outlook account. I'm trying not to upload it on the OneDrive(?) because I don't like creating accounts for sites I will probably never use again, I didn't even want to create one for this forum lol.

Is there any other way I can post the file so everyone can see? I just tried doing a link sharing with Google Drive but it would show my email.