Hi all, I am still busy with the attendance register and need to solve the following formula.
Adding and subtracting hours in the same formula, I already changed the format to [h]:mm but still gets the #######, why?
View best response
Excel doesn't show negative time, you may use =C2-A2-B2. If you need both positive and negative in same column, as variant you may transform ABS to text with adding SIGN; or use some other workaround.
I am sure there is a way to bypass the negative value.
I found the solution....no complicated formula needed. Just change the total cell in advance settings "Use 1904 date system"