ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   "the formula in this cell differs from the formula in this area o. (https://www.excelbanter.com/excel-worksheet-functions/57465-formula-cell-differs-formula-area-o.html)

~Summiya~

"the formula in this cell differs from the formula in this area o.
 
I keep getting this error "the formula in this cell differs from the formula
in this area of the spreadsheet" when I put a formula in my time spreadsheet.
I know it is something simple but cannot figure out what! Because of this
error the total hours worked will not total correctly. I am using military
time to calculate my hours worked as it rounds up with how I am paid.

Niek Otten

"the formula in this cell differs from the formula in this area o.
 
What formulas in what cells? Which one gave the "error" message? What is the
difference? What are the input values? What result did you expect? What did
you get instead?

--
Kind regards,

Niek Otten

"~Summiya~" wrote in message
...
I keep getting this error "the formula in this cell differs from the
formula
in this area of the spreadsheet" when I put a formula in my time
spreadsheet.
I know it is something simple but cannot figure out what! Because of this
error the total hours worked will not total correctly. I am using
military
time to calculate my hours worked as it rounds up with how I am paid.





All times are GMT +1. The time now is 10:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com