How to convert a (-) number to (+) within a formula and add to TIME

[zx6roo]

In cell E4 I have the formula =IFERROR(A4+TIME(0,D4,0),("")).
Where A4 = time and D4 = a number. The formula adds the number to increase the time.

Problem:
Sometimes the number in column D is a negative but I still want to increase the time by that number, as in treat it like a positive.

So I changed the formula to this =IFERROR(A4+TIME(0,ABS(D4),0),("")).
It works however if I have -4 in the cell it only adds on 3 minutes instead of 4.

Can anyone help to make the -4 minutes actually add on as 4 minutes in time, not 3?

 

[LFKim2018]

I tried your formula - it is working properly.
the problem might be somewhere else - not in the formula -- because ABS(D4) gets only the absolute value of the cell.
check your database...

 

[zx6roo]

It is to. I changed the format on D4 to 2 decimal places and it's actually 3.7 so I can see why it only adds on 3 minutes.
It's a lookup field so I've put roundup on it and now it works correctly.
Thanks for being a second pair of eye LFKim2018

 

[LFKim2018]

It is to. I changed the format on D4 to 2 decimal places and it's actually 3.7 so I can see why it only adds on 3 minutes.
It's a lookup field so I've put roundup on it and now it works correctly.
Thanks for being a second pair of eye LFKim2018

glad to hear that..