Calculation Formula using minutes format - currently #value

[TomDrury89]

Hi All,

I am hoping for your help.

I have a report that exported in time/minutes format and I am trying to calculate standard hours however i am getting #value errors when trying to resolve.

I basically want to check to see if the normal minus extra and rdo equals to zero. (Normal and leave - Extra Normal - RDO Neg) - Standard Hours

I was thinking maybe I could multiply the figures 24 then completed the calculations, however I am getting #values with the blank cells.

Any help or guidance would be appreciated!

Standard Hours	Normal and Leave Total	Extra Normal	RDO Neg
35:00	35:00
15:30	15:30
38:00	39:42		1:42
24:00	32:00	8:00
38:00	38:00
38:00	38:51		0:51
38:00	38:00
28:45	35:00	5:15

 

[jasonb75]

Try enclosing the cell references in your formula in the N function, e.g. change A1 to N(A1) This will evaluate any blank cells as zero instead of seeing a nullstring, which is the most likely cause of the error.