fix an error #VALUE1 in formula with absolute referencing

Occasional Visitor

i m trying to use a formula containing  absolute referencing but i keep getting error message #VALUE!.

1 Reply
Hi! You need to change your O/T 2 Hours from dashes to zeros, excel is reading that as text and can't do math as text. If you change that you'll be good to go!