SOLVED

Adding hours more than 24

Brass Contributor

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?

clipboard_image_0.png

3 Replies

@Janedb 

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.

best response confirmed by Janedb (Brass Contributor)
Solution

@Sergei Baklan 

I found the solution....no complicated formula needed. Just change the total cell in advance settings "Use 1904 date system"

 

clipboard_image_0.png

1 best response

Accepted Solutions
best response confirmed by Janedb (Brass Contributor)
Solution

@Sergei Baklan 

I found the solution....no complicated formula needed. Just change the total cell in advance settings "Use 1904 date system"

 

clipboard_image_0.png

View solution in original post