Adding negative and positive times

[tiffs1021]

I am trying to add negative time, hours and minutes (-1:32) to positive time (0:34). These are totals for hours worked above 40 hours. I have changed to the 1904 date system but my formulas aren't working. I'm not very familiar with Excel. I'm trying the formula =SUM(A1+A2) with A1 and A2 being in time format. I have found many threads about this but none that I find fit what I'm looking for.
Please help!

 

[Exceladd1ct]

Hello, keep 1904 date system, but format the cells as Time.

A1 =-VALUE("10:20")
A2 =-VALUE("2:20")
A3 =A1+A2 (A1 and A2 must be formatted as Time)
Let me know if it work please.

 

[mazher]

I am trying to add negative time, hours and minutes (-1:32) to positive time (0:34). These are totals for hours worked above 40 hours. I have changed to the 1904 date system but my formulas aren't working. I'm not very familiar with Excel. I'm trying the formula =SUM(A1+A2) with A1 and A2 being in time format. I have found many threads about this but none that I find fit what I'm looking for.
Please help!

A good expalantion can be found here

https://www.youtube.com/watch?v=yeXnDslp6xo

Hope that helps you in better understanding.

 

[tiffs1021]

Thank you! This worked!

 

[Exceladd1ct]

Glad to help.