Jan 09 2020 12:58 AM
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?
Jan 09 2020 01:04 AM
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.
Jan 09 2020 03:10 AM - edited Jan 09 2020 03:17 AM
I am sure there is a way to bypass the negative value.
Jan 09 2020 03:21 AM
SolutionI found the solution....no complicated formula needed. Just change the total cell in advance settings "Use 1904 date system"
Jan 09 2020 03:21 AM
SolutionI found the solution....no complicated formula needed. Just change the total cell in advance settings "Use 1904 date system"