fix an error #VALUE1 in formula with absolute referencing

[oznicky]

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

[#2]

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!